How to Populate Dropdownlist inside EditITemTemplate of gridview

Question

Hello Everyone Please help me how to bind dropdownlist inside edit item template of gridview heres my code.. ASPX BorderColor=#0070C0 GridLines=Both OnRowDataBound=gridDept_RowDataBound AutoGenerateColumns=False CssClass=Content CellPadding=3 onrowcancelingedit=gridDept_RowCancelingEdit onrowdeleting=gridDept_RowDeleting onrowediting=gridDept_RowEditing onrowupdating=gridDept_RowUpdating DataKeyNames=Dept_Idx> --------------------------- CS protected void gridDept_RowCancelingEdit(object sender GridViewCancelEditEventArgs e) { gridDept.EditIndex = -1; BindDept(); } protected void gridDept_RowDataBound(object sender GridViewRowEventArgs e) { int id = 0; if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState & DataControlRowState.Edit) > 0) { Dim_Department d = (e.Row.DataItem as Dim_Department); TextBox txtDept_Sort = (TextBox)e.Row.FindControl(txtDept_Sort); TextBox txtDept_Code = (TextBox)e.Row.FindControl(txtDept_ShortName); TextBox txtDept_Name = (TextBox)e.Row.FindControl(txtDept_Name); txtDept_Sort.Text = Convert.ToInt64(d.Dept_Sort).ToString(); txtDept_Code.Text = d.Dept_ShortName; txtDept_Name.Text = d.Dept_Name; } else if (e.Row.RowType == DataControlRowType.DataRow) { id = Int32.Parse(e.Row.Cells[0].ToString()); Dim_Function d = (e.Row.DataItem as Dim_Function); DropDownList dropFunc = (DropDownList)e.Row.FindControl(dropFunc); dropFunc.DataSource = d; dropFunc.DataBind(); //dropFunc.Items.Clear(); //dropFunc.Items.Add(new ListItem(Select 0)); //dropFunc.SelectedValue = Convert.ToInt64(d.Func_Idx).ToString(); } } protected void gridDept_RowDeleting(object sender GridViewDeleteEventArgs e) { int id = Int32.Parse(gridDept.DataKeys[e.RowIndex].Value.ToString()); CLMSDataContext context = new CLMSDataContext(); try { Dim_Department f = context.Dim_Departments.Single(x => x.Dept_Idx == id); context.Dim_Departments.DeleteOnSubmit(f); context.SubmitChanges(); BindDept(); successTitle.InnerText = Delete Result; pSuccessMessage1.InnerText = f.Dept_Name +  has been successfully deleted.; btnSuccessOk.Focus(); modpopSuccess.Show(); } catch (Exception ex) { errorTitle.InnerText = Delete Failed; pErrorMessage.InnerText = ex.Message; OkButton.Focus(); modpopError.Show(); } finally { context.Dispose(); } } protected void gridDept_RowEditing(object sender GridViewEditEventArgs e) { gridDept.EditIndex = e.NewEditIndex; BindDept(); } protected void gridDept_RowUpdating(object sender GridViewUpdateEventArgs e) { Int64 id = Int64.Parse(gridDept.DataKeys[e.RowIndex].Value.ToString()); CLMSDataContext context = new CLMSDataContext(); try { Dim_Department dept = context.Dim_Departments.Single(x => x.Dept_Idx == id); TextBox txtDept_Sort = gridDept.Rows[e.RowIndex].FindControl(txtDept_Sort) as TextBox; TextBox txtDept_Code = gridDept.Rows[e.RowIndex].FindControl(txtDept_ShortName) as TextBox; TextBox txtDept_Name = gridDept.Rows[e.RowIndex].FindControl(txtDept_Name) as TextBox; DropDownList dropFunc = (DropDownList)gridDept.Rows[e.RowIndex].FindControl(dropFunc); dept.Dept_Sort = Convert.ToInt32(txtDept_Sort.Text); dept.Dept_ShortName = txtDept_Code.Text; dept.Dept_Name = txtDept_Name.Text; dept.Func_PIdx = Convert.ToInt64(dropFunc.SelectedValue.ToString()); context.SubmitChanges(); successTitle.InnerText = Save Results; pSuccessMessage1.InnerText = Update Completed!; btnSuccessOk.Focus(); modpopSuccess.Show(); } catch (Exception ex) { errorTitle.InnerText = Error Encountered; pErrorMessage.InnerText = ex.Message; OkButton.Focus(); modpopError.Show(); } finally { context.Dispose(); gridFunc.EditIndex = -1; BindDept(); } } } }

shahid ali · Answer

Check this if (GvWorkingDays.EditIndex == e.Row.RowIndex) { if (e.Row.RowType == DataControlRowType.DataRow) { { Label lblSN = (Label)e.Row.FindControl(lblSN); lblSN.Text = (e.Row.RowIndex + 1).ToString(); ////if ((e.Row.RowState & DataControlRowState.Edit) > 0) if (e.Row.RowState == DataControlRowState.Edit) { DropDownList ddlDaySetup = (DropDownList)e.Row.FindControl(ddlDaySetup); //string query =  select 0 as 'SN'0 as Id'Select' as DaySetup union all select 1 as 'SN'Id DaySetup from tblDaySetup order by SNDaySetup ; //SqlCommand cmd = new SqlCommand(query); //ddlNtWrkNoInst.DataSource = GetData(cmd); Setting s = new Setting(); ddlNtWrkNoInst.DataSource = s.SetDropdownList(2); ddlNtWrkNoInst.DataTextField = DaySetup; ddlNtWrkNoInst.DataValueField = Id; ddlNtWrkNoInst.DataBind(); //DataRowView dr = e.Row.DataItem as DataRowView; //ddlDaySetup.SelectedValue = dr[Id].ToString(); } } } }

mary jean ligas · Answer

But I'am using query joining two tables in sql how will iam going to bind them in gridview.. when i clicked edit then error object reference set to null

Sandeep Singh Shekhawat · Answer

here is an Example Which populate dropdown list in Edit Item template http://www.aspsnippets.com/Articles/Populate-DropDownList-with-Selected-Value-in-EditItemTemplate-of-GridView-in-ASPNet.aspx Populate Dropdown list in side Edit Item template. Here we are populating city from cutomers table protected void RowDataBound( object sender GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType .DataRow && gvCustomers.EditIndex == e.Row.RowIndex) { //Find Dropdown list DropDownList ddlCities = ( DropDownList )e.Row.FindControl( ddlCities ); string query = select distinct city from customers ; SqlCommand cmd = new SqlCommand (query); //Populate Dropdown ddlCities.DataSource = GetData(cmd); ddlCities.DataTextField = city ; ddlCities.DataValueField = city ; ddlCities.DataBind(); ddlCities.Items.FindByValue((e.Row.FindControl( lblCity ) as Label ).Text).Selected = true ; } } private DataTable GetData( SqlCommand cmd) { string strConnString = ConfigurationManager .ConnectionStrings[ conString ].ConnectionString; using ( SqlConnection con = new SqlConnection (strConnString)) { using ( SqlDataAdapter sda = new SqlDataAdapter ()) { cmd.Connection = con; sda.SelectCommand = cmd; using ( DataTable dt = new DataTable ()) { sda.Fill(dt); return dt; } } } }

sarfaraj md · Answer

Inside the EditItemtemplate you just bind the ddl with ' ' function in .aspx and the bind the particular ddl in rowdatabound or databound event of Gridview. definitely it'll work..........