private void SetInitRow() { DataTable dt = new DataTable(); DataRow dr = null; //dt.Columns.Add(new DataColumn("ITEMCODE", typeof(string))); dt.Columns.Add(new DataColumn("ITEMNAME", typeof(string))); dt.Columns.Add(new DataColumn("ITEM TYPE", typeof(string))); dt.Columns.Add(new DataColumn("UNITS", typeof(string))); dt.Columns.Add(new DataColumn("QTY", typeof(string))); dt.Columns.Add(new DataColumn("SALERATE", typeof(string))); dt.Columns.Add(new DataColumn("SALERETURN", typeof(string))); dt.Columns.Add(new DataColumn("RECOVERY", typeof(string))); dt.Columns.Add(new DataColumn("OUTSTANDING", typeof(string))); dt.Columns.Add(new DataColumn("AMOUNT", typeof(string))); dt.Columns.Add(new DataColumn("REMARKS", typeof(string))); dt.Columns.Add(new DataColumn("ddsr", typeof(string))); dr = dt.NewRow(); //dr["ITEMCODE"] = string.Empty; dr["ITEMNAME"] = string.Empty; dr["ITEM TYPE"] = string.Empty; dr["UNITS"] = string.Empty; dr["QTY"] = "0.00"; dr["SALERATE"] = "0.00"; dr["SALERETURN"] = "0.00"; dr["RECOVERY"] = "0.00"; dr["OUTSTANDING"] = "0.00"; dr["AMOUNT"] = "0.00"; dr["REMARKS"] = string.Empty; dr["ddsr"] = "0.00"; dt.Rows.Add(dr); //Store the DataTable in ViewState ViewState["dt_adItm"] = dt; GVPro1.DataSource = dt; GVPro1.DataBind(); int rowIndex1 = 0; LinkButton linkbtndel = (LinkButton)GVPro1.Rows[rowIndex1].Cells[0].FindControl("linkbtndel"); linkbtndel.Visible = false; }
protected void GVPro1_RowDeleting(object sender, GridViewDeleteEventArgs e) { if (ViewState["dt_adItm"] != null) { DataTable dt = (DataTable)ViewState["dt_adItm"]; DataRow drCurrentRow = null; int rowIndex = Convert.ToInt32(e.RowIndex); if (dt.Rows.Count > 1) { dt.Rows.Remove(dt.Rows[rowIndex]); drCurrentRow = dt.NewRow(); ViewState["dt_adItm"] = dt; GVPro1.DataSource = dt; GVPro1.DataBind(); SetPreRow(); //ptnSno(); } } }
protected void GVDSR_RowCommand(object sender, GridViewCommandEventArgs e) { try { GridViewRow row; //string PURID = GVDSR.DataKeys[row.RowIndex].Values[0].ToString(); if (e.CommandName == "Select") { row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); string MDSRID = Server.HtmlDecode(GVDSR.Rows[row.RowIndex].Cells[0].Text.ToString()); string cmdtxt = "select tbl_Mdsr.CustomerID, CustomerName, replace(convert(NVARCHAR, dsrdat, 101), ' ', '/') as [dsrdat],tbl_Mdsr.dsrid from tbl_Mdsr inner join tbl_ddsr on " + " tbl_Mdsr.dsrid = tbl_ddsr.dsrid inner join Customers_ on tbl_Mdsr.CustomerID = Customers_.CustomerID inner join Products on tbl_ddsr.ProductID = Products.ProductID " + " where tbl_Mdsr.CompanyId = '" + Session["CompanyID"] + "' and tbl_Mdsr.BranchId= '" + Session["BranchID"] + "' and tbl_Mdsr.dsrid =" + MDSRID + ""; //string cmdtxt = " select a.mPurID, b.dPurId, b.mPurId, a.ven_id, a.VndrAdd, a.VndrCntct,a.PurNo, a.mPurDate, a.CreatedBy, a.CreatedAt, a.cnic, a.ntnno, a.tobePrntd,b.Dpurid, b.ProNam, b.ProDes, b.Qty, b.Total, b.subtotl, b.unit, b.cost, b.protyp,b.grossttal from MPurchase a inner join DPurchase b on a.mPurID = b.mPurID where a.MPurID =" + MPurID + ""; SqlCommand cmdSlct = new SqlCommand(cmdtxt, con); SqlDataAdapter adp = new SqlDataAdapter(cmdSlct); DataTable dt = new DataTable(); adp.Fill(dt); if (dt.Rows.Count > 0) { HFdsrID.Value = dt.Rows[0]["dsrid"].ToString(); TBdsrdat.Text = dt.Rows[0]["dsrdat"].ToString(); DDL_Cust.SelectedValue = dt.Rows[0]["CustomerID"].ToString(); string cmdDettxt = " select ddsr,'' as [ITEM TYPE],tbl_Ddsr.ProductID as [ITEMNAME],ProductName,untid as [UNITS],tbl_Ddsr.dsrid,Qty,Amt as [AMOUNT], salrat as [SALERATE],salrturn as [SALERETURN],recvry as [RECOVERY],outstan as [OUTSTANDING],ttlamt, '' as [AMOUNT],dsrrmk as[REMARKS] from tbl_Ddsr " + " inner join tbl_Mdsr on tbl_Ddsr.dsrid = tbl_Mdsr.dsrid inner join Products on tbl_Ddsr.ProductID = Products.ProductID" + " where tbl_Mdsr.CompanyId = '" + Session["CompanyID"] + "' and tbl_Mdsr.BranchId='" + Session["BranchID"] + "' and tbl_Ddsr.dsrid = " + MDSRID + ""; DataTable dt_Det = new DataTable(); dt_Det = DataAccess.DBConnection.GetDataTable(cmdDettxt); if (dt_Det.Rows.Count > 0) { GVPro1.DataSource = dt_Det; GVPro1.DataBind(); ViewState["dt_adItm"] = dt_Det; for (int j = 0; j < dt_Det.Rows.Count; j++) { for (int i = 0; i < GVPro1.Rows.Count; i++) { Label lbl_pro = (Label)GVPro1.Rows[i].FindControl("lblPurItm"); DropDownList DDL_Itm = (DropDownList)GVPro1.Rows[i].FindControl("DDL_Itm"); Label lbl_unt = (Label)GVPro1.Rows[i].FindControl("lbl_unt"); DropDownList DDL_Unt = (DropDownList)GVPro1.Rows[i].FindControl("DDL_Unt"); Label HFDSR = (Label)GVPro1.Rows[i].FindControl("HFDSR"); Label lbl_Flag = (Label)GVPro1.Rows[i].FindControl("lbl_Flag"); TextBox TextBox1 = (TextBox)GVPro1.Rows[i].FindControl("TextBox1"); //lbl_pro.Text = dt_Det.Rows[j]["ITEMNAME"].ToString(); DDL_Itm.SelectedValue = lbl_pro.Text.Trim(); //lbl_unt.Text = dt_Det.Rows[j]["UNITS"].ToString(); DDL_Unt.SelectedValue = lbl_unt.Text.Trim(); TextBox1.Text = DDL_Itm.SelectedItem.Text; //dt_Det.Rows[j]["ProductName"].ToString(); //HiddenField HFDSR = (HiddenField)GVPro1.Rows[i].FindControl("HFDSR"); //HFDSR.Text = dt_Det.Rows[j]["ddsr"].ToString(); tbtotal.Text = dt_Det.Rows[j]["ttlamt"].ToString(); lbl_Flag.Text = "1"; btnUpd.Enabled = true; } } } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true); lblalert.Text = "No Record Found!!"; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true); lblalert.Text = ex.Message; } }
private void AddNewRow() { int rowIndex = 0; if (ViewState["dt_adItm"] != null) { DataTable dt = (DataTable)ViewState["dt_adItm"]; DataRow drRow = null; if (dt.Rows.Count > 0) { for (int i = 1; i <= dt.Rows.Count; i++) { //extract the Controls values DropDownList DDL_Itm = (DropDownList)GVPro1.Rows[rowIndex].Cells[0].FindControl("DDL_Itm"); TextBox TextBox1 = (TextBox)GVPro1.Rows[rowIndex].Cells[0].FindControl("TextBox1"); DropDownList DDL_Itmtyp = (DropDownList)GVPro1.Rows[rowIndex].Cells[1].FindControl("DDL_Itmtyp"); DropDownList DDL_Unt = (DropDownList)GVPro1.Rows[rowIndex].Cells[2].FindControl("DDL_Unt"); TextBox TBQty = (TextBox)GVPro1.Rows[rowIndex].Cells[3].FindControl("TBQty"); TextBox TBSalRat = (TextBox)GVPro1.Rows[rowIndex].Cells[4].FindControl("TBSalRat"); TextBox TBSalRtrn = (TextBox)GVPro1.Rows[rowIndex].Cells[5].FindControl("TBSalRtrn"); TextBox TBRecy = (TextBox)GVPro1.Rows[rowIndex].Cells[6].FindControl("TBRecy"); TextBox lblOutstan = (TextBox)GVPro1.Rows[rowIndex].Cells[7].FindControl("lblOutstan"); TextBox TBAmt = (TextBox)GVPro1.Rows[rowIndex].Cells[8].FindControl("TBAmt"); TextBox TBRmk = (TextBox)GVPro1.Rows[rowIndex].Cells[9].FindControl("TBRmk"); //TextBox lblttl = (TextBox)GVPro1.Rows[rowIndex].Cells[8].FindControl("lblttl"); Label dsrid = (Label)GVPro1.FooterRow.Cells[10].FindControl("HFDSR"); LinkButton linkbtndel = (LinkButton)GVPro1.Rows[rowIndex].Cells[0].FindControl("linkbtndel"); linkbtndel.Visible = true; drRow = dt.NewRow(); //dt.Rows[i - 1]["ITEMCODE"] = DDL_Unt.Text; dt.Rows[i - 1]["ITEMNAME"] = DDL_Itm.SelectedValue; TextBox1.Text = DDL_Itm.SelectedItem.Text; dt.Rows[i - 1]["ITEM TYPE"] = DDL_Itmtyp.Text; dt.Rows[i - 1]["UNITS"] = DDL_Unt.SelectedValue; dt.Rows[i - 1]["QTY"] = TBQty.Text; dt.Rows[i - 1]["SALERATE"] = TBSalRat.Text; dt.Rows[i - 1]["SALERETURN"] = TBSalRtrn.Text; dt.Rows[i - 1]["RECOVERY"] = TBRecy.Text; dt.Rows[i - 1]["OUTSTANDING"] = lblOutstan.Text; dt.Rows[i - 1]["AMOUNT"] = TBAmt.Text; dt.Rows[i - 1]["REMARKS"] = TBRmk.Text; //dt.Rows[i - 1]["ddsr"] = dsrid.Text; rowIndex++; //DDL_Unt.Focus(); } dt.Rows.Add(drRow); ViewState["dt_adItm"] = dt; GVPro1.DataSource = dt; GVPro1.DataBind(); } } else { Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreRow(); }