Exemple #1
0
        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]);
        }