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]); }