private void LoadGrid(string DCNumber, string PONumber, string DealerCode) { DataTable dtParts = new DataTable(); DataSet ds = new DataSet(); DataSet dsParts = new DataSet(); SqlDataReader dr = null; string mPONo = ""; string mDCNo = ""; if (PONumber == "") { mPONo = this.Session["PONumber"].ToString(); } else { mPONo = PONumber; } //if (DCNumber == "") //{ // mDCNo = this.Session["DCNumber"].ToString(); //} //else //{ // mDCNo = DCNumber; //} try { SqlParameter[] param = { new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@PONO", SqlDbType.Char, 10) }; param[0].Value = this.Session["DealerCode"].ToString(); param[1].Value = mPONo; myFunc.ExecuteSP("Sp_2W_GetPO_ForDC", param, ref dr); dtParts.Load(dr); //ds = (DataSet)ViewState["ObjPOds"]; ds = (DataSet)this.Session["DCDataSet"]; ds.Tables["DCItems"].Rows.Clear(); if (dtParts.Rows.Count != 0) { foreach (DataRow dRow in dtParts.Rows) { SqlParameter[] paramPO_Parts = { new SqlParameter("@PONO", SqlDbType.Char, 10), new SqlParameter("@DealerCode", SqlDbType.Char, 10), new SqlParameter("@ItemCode", SqlDbType.Char, 10) }; paramPO_Parts[0].Value = mPONo; paramPO_Parts[1].Value = this.Session["DealerCode"].ToString(); paramPO_Parts[2].Value = dRow["ItemCode"].ToString(); dsParts = myFunc.FillDataSet("SP_Spare_Get_PartPOInfo", paramPO_Parts); DataRow row = ds.Tables["DCItems"].NewRow(); row["Sno"] = ds.Tables["DCItems"].Rows.Count + 1; row["PartItemNo"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "PartItemNo", "Item"); row["PartItemName"] = myFunc.GetStringValuesAgainstCodes("ItemCode", paramPO_Parts[2].Value.ToString(), "ItemDesc", "Item"); row["unit"] = myFunc.GetStringValuesAgainstCodes("UnitCode='" + dRow["UnitCode"].ToString() + "'", "unit", "UnitDesc"); row["POQuantity"] = dsParts.Tables[0].Rows[0]["POQty"].ToString(); row["BalanceQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); if (DCNumber == "") { row["DCQuantity"] = dsParts.Tables[0].Rows[0]["BalanceQty"].ToString(); } else { row["DCQuantity"] = myFunc.GetDCQty(DCNumber, dRow["ItemCode"].ToString()); } row["Selected"] = true; ds.Tables["DCItems"].Rows.Add(row); } //if (GridViewDC.VisibleRowCount > 0) //{ // CheckBox chkSelect; // TextBox txtDCQty; // Label lblBalQty; // foreach (GridViewRow gvr in GridViewDC.Rows) // { // chkSelect = (CheckBox)gvr.Cells[0].FindControl("ChkSelect"); // txtDCQty = (TextBox)gvr.Cells[6].FindControl("txtDCQuantity"); // lblBalQty = (Label)gvr.Cells[5].FindControl("LbBalanceQuantity"); // chkSelect.Checked = true; // txtDCQty.Text = lblBalQty.Text; // //chkSelect.Enabled = false; // } //} //txtVendorNo.Text = dsVendorInfo.Tables[0].Rows[0]["vendorCode"].ToString(); //txtVendorDesc.Text = dsVendorInfo.Tables[0].Rows[0]["vendorDesc"].ToString(); } Session["DCDataSet"] = ds; GridViewDC.DataSource = ds.Tables["DCItems"]; GridViewDC.DataSourceID = null; GridViewDC.DataBind(); } catch (Exception ex) { //ObjGeneral.UserMsg(LbErr, Color.Red, "Error: " + ex.Message, txtDCNo); } }