private DataTable GetDs3()
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
string rbno = Session["SalesOrderNo"].ToString();
SqlDataAdapter adp3 = new SqlDataAdapter("select * from SalesReturns where BillNo='" + rbno + "'", con);
SalesReturnsDataset ds4 = new SalesReturnsDataset();
con.Open();
adp3.Fill(ds4);
// find retail bill no using primary key
//string Code = ds3.Tables[1].Rows[0]["Code"].ToString();
//Session["Code"] = Code;
return(ds4.Tables[1]);
}
private DataTable GetDs3()
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
// SqlConnection con = new SqlConnection("Data Source=MARY-PC;Initial Catalog=A To Z Life Style(India) Pvt Ltd Retail 01-04-2016 To 31-03-2017;Integrated Security=True");
string rbno = Session["DebitNoteNo"].ToString();
SqlDataAdapter adp3 = new SqlDataAdapter("select * from SalesReturns where BillNo='" + rbno + "'", con);
SalesReturnsDataset ds4 = new SalesReturnsDataset();
con.Open();
adp3.Fill(ds4);
// find retail bill no using primary key
//string Code = ds3.Tables[1].Rows[0]["Code"].ToString();
//Session["Code"] = Code;
return(ds4.Tables[1]);
}
