private DataTable GetDs2() { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString); string rbno = Session["SalesOrderNo"].ToString(); SqlDataAdapter adp3 = new SqlDataAdapter("select * from InventoryTaxes where Code='" + rbno + "'", con); InventoryTaxesDataSet ds3 = new InventoryTaxesDataSet(); con.Open(); adp3.Fill(ds3); // find retail bill no using primary key //string Code = ds3.Tables[1].Rows[0]["Code"].ToString(); //Session["Code"] = Code; return(ds3.Tables[1]); }
private DataTable GetDs2() { // 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"); SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString); string rbno = Session["PurchaseReturnNo"].ToString(); SqlDataAdapter adp3 = new SqlDataAdapter("select * from PurchaseInventoryTaxes where Code='" + rbno + "'", con); InventoryTaxesDataSet ds3 = new InventoryTaxesDataSet(); con.Open(); adp3.Fill(ds3); // find retail bill no using primary key //string Code = ds3.Tables[1].Rows[0]["Code"].ToString(); //Session["Code"] = Code; return(ds3.Tables[1]); }