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