private DataTable GetDs(int RBId) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString); string RetailBillNo = Session["RetailBillNo"].ToString(); SqlDataAdapter adp1 = new SqlDataAdapter("select * from RetailBillItems where RetailBillNo='" + RetailBillNo + "'", con); RetailManagementDataSet4 ds1 = new RetailManagementDataSet4(); con.Open(); adp1.Fill(ds1); return(ds1.Tables[1]); }
private DataTable GetDs(int RBId) { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString); string RetailBillNo = Session["RetailBillNo"].ToString(); SqlDataAdapter adp1 = new SqlDataAdapter("select * from RetailBillItems where RetailBillNo='" + RetailBillNo + "'", con); RetailManagementDataSet4 ds1 = new RetailManagementDataSet4(); con.Open(); adp1.Fill(ds1); //Session["Barcode"] = @"file:///D:\Shraddha\RetailApp\ATOZ\MvcRetailApp\Images\" + ds1.Tables[1].Rows[0]["Barcode"].ToString(); //for (int i = 0; i < ds1.Tables[1].Rows.Count; i++) //{ // ds1.Tables[1].Rows[i]["Barcode"] = @"file:///D:\Shraddha\RetailApp\ATOZ\MvcRetailApp\Images\" + ds1.Tables[1].Rows[i]["Barcode"].ToString(); //} return(ds1.Tables[1]); }