private void SetInitRow() { DataTable dt = new DataTable(); //DataRow dr = null; dt.Columns.Add(new DataColumn("PRODUCT", typeof(string))); dt.Columns.Add(new DataColumn("SIZE", typeof(string))); dt.Columns.Add(new DataColumn("QTY", typeof(string))); dt.Columns.Add(new DataColumn("RATE", typeof(string))); dt.Columns.Add(new DataColumn("AMT", typeof(string))); dt.Columns.Add(new DataColumn("DSal_id", typeof(string))); ViewState["dt_salItms"] = dt; GVItms.DataSource = dt; GVItms.DataBind(); // For Stock DataTable dtstk = new DataTable(); //DataRow drstk = null; dtstk.Columns.Add(new DataColumn("SIZE", typeof(string))); dtstk.Columns.Add(new DataColumn("QTY", typeof(string))); ViewState["dt_salItm"] = dtstk; GVStkItems.DataSource = dtstk; GVStkItems.DataBind(); //dr = dt.NewRow(); //dr["PRODUCT"] = string.Empty; //dr["SIZE"] = string.Empty; //dr["QTY"] = string.Empty; //dr["RATE"] = string.Empty; //dr["AMT"] = string.Empty; //dr["DSal_id"] = string.Empty; //dt.Rows.Add(dr); //Store the DataTable in ViewState }
private void AddNewItems() { int rowIndex = 0; if (ViewState["dt_salItms"] != null) { DataTable dt = (DataTable)ViewState["dt_salItms"]; DataRow drRow = null; //if (dt.Rows.Count > 0) { //drRow = dt.NewRow(); //for (int i = 1; i <= dt.Rows.Count; i++) //{ // //extract the TextBox values // for (int k = 0; k < GVItms.Rows.Count; k++) // { // Label lbl_Pro = (Label)GVItms.Rows[k].Cells[0].FindControl("lbl_Pro"); // TextBox itmsiz = (TextBox)GVItms.Rows[k].Cells[1].FindControl("itmsiz"); // TextBox ItmQty = (TextBox)GVItms.Rows[k].Cells[2].FindControl("ItmQty"); // TextBox TBrat = (TextBox)GVItms.Rows[k].Cells[3].FindControl("TBrat"); // TextBox TBamt = (TextBox)GVItms.Rows[k].Cells[4].FindControl("TBamt"); // HiddenField HFDSal = (HiddenField)GVItms.Rows[k].Cells[5].FindControl("HFDSal"); // dt.Rows[i - 1]["PRODUCT"] = lbl_Pro.Text; // dt.Rows[i - 1]["SIZE"] = itmsiz.Text; // dt.Rows[i - 1]["QTY"] = ItmQty.Text; // dt.Rows[i - 1]["RATE"] = TBrat.Text; // dt.Rows[i - 1]["AMT"] = TBamt.Text; // dt.Rows[i - 1]["DSal_id"] = HFDSal.Value; // rowIndex++; // } //} DataTable dt3 = (DataTable)ViewState["dt_salItm"]; if (dt3.Rows.Count > 0) { for (int i = 0; i < dt3.Rows.Count; i++) { dt3.Rows[i]["RATE"] = TB_Rat.Text; //if (dt3.Rows[i]["QTY"] != "0") //{ // dt3.Rows[i]["QTY"] = "0"; //} } dt.Merge(dt3, true, MissingSchemaAction.Ignore); } //dt.Rows.Add(drRow); ViewState["dt_salItms"] = dt; GVItms.DataSource = dt; GVItms.DataBind(); } } else { Response.Write("ViewState is null"); } SetPreRowitm(); }