protected void CMBItem_SelectedIndexChanged(object sender, EventArgs e) { DropDownList lb = (DropDownList)sender; GridViewRow gvRow = (GridViewRow)lb.NamingContainer; int rowID = gvRow.RowIndex; if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; connect.cn(); SqlCommand sqlcmd = new SqlCommand("Get_Item_PurchasePrice", connect.cn()); sqlcmd.Parameters.AddWithValue("@IMSNO", lb.SelectedValue); sqlcmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(sqlcmd); DataTable dt1 = new DataTable(); da.Fill(dt1); if (dt1.Rows.Count > 0) { dt.Rows[rowID][4] = dt1.Rows[0][0].ToString(); dt.Rows[rowID][5] = dt1.Rows[0][1].ToString(); } ViewState["CurrentTable"] = dt; //Re bind the GridView for the updated data Gridview2.DataSource = dt; Gridview2.DataBind(); } SetPreviousData(); } private void SetPreviousData() { int rowIndex = 0; if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; if (dt.Rows.Count > 0) { AddGridcombo(); LoadItemList(); for (int i = 0; i < dt.Rows.Count; i++) { DropDownList box4 = (DropDownList)Gridview2.Rows[rowIndex].Cells[1].FindControl("CMBGodown"); DropDownList box7 = (DropDownList)Gridview2.Rows[rowIndex].Cells[1].FindControl("CMBItem"); TextBox box1 = (TextBox)Gridview2.Rows[rowIndex].Cells[2].FindControl("txtqty"); TextBox box2 = (TextBox)Gridview2.Rows[rowIndex].Cells[3].FindControl("txtrate"); TextBox box3 = (TextBox)Gridview2.Rows[rowIndex].Cells[4].FindControl("txttaxpercent"); TextBox box5 = (TextBox)Gridview2.Rows[rowIndex].Cells[5].FindControl("txttaxvalue"); TextBox box6 = (TextBox)Gridview2.Rows[rowIndex].Cells[6].FindControl("txtamt"); box4.Text = dt.Rows[i]["Column1"].ToString(); box1.Text = dt.Rows[i]["Column3"].ToString(); box2.Text = dt.Rows[i]["Column4"].ToString(); box3.Text = dt.Rows[i]["Column5"].ToString(); box5.Text = dt.Rows[i]["Column6"].ToString(); box6.Text = dt.Rows[i]["Column7"].ToString(); box7.Text = dt.Rows[i]["Column2"].ToString(); rowIndex++; } // dtCurrentTable.Rows.Add(drCurrentRow); ViewState["CurrentTable"] = dt; // Gridview2.DataSource = dt; //Gridview2.DataBind(); // AddGridcombo(); } } private void LoadItemList() { try { connect.cnopen(); foreach (GridViewRow grdRow in Gridview2.Rows) { DropDownList drdlist = (DropDownList)(Gridview2.Rows[grdRow.RowIndex].Cells[2].FindControl("CMBItem")); // BeginTransaction("LoadItemList"); // SqlCommand sqlcmd = new SqlCommand("FETCH_PURCHASE_DTL_SP",connect.cn()); SqlCommand sqlcmd = new SqlCommand("FETCH_ITEM_LIST_SP", connect.cn()); sqlcmd.CommandType=CommandType.StoredProcedure; SqlDataAdapter da=new SqlDataAdapter(sqlcmd); DataTable dt = new DataTable(); da.Fill(dt); drdlist.DataSource = dt; drdlist.DataValueField = "IM_SERIALNO"; drdlist.DataTextField = "IM_ITEMNAME"; drdlist.DataBind(); } } catch { } }
Page.IsPostBack
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)