Binding Dropdownlist in gridview

Question

Hi All i am binding a dropdownlist [dynamically] in the edit templet field of a gridview[rowEditing event] it is binding properly but getting the selected value as different from what it is in the item templet field !.[In the item templet field the field is displayed in a label] Language c#

Lalit M · Answer

Bind the DropDownList like normal (set DataSourceID DataTextField DataValueField) and the SelectedValue field. AutoPostBack should be enabled. In the OnSelectedIndexChanged: protected void DropDownSelectedIndexChanged(object sender EventArgs e) { //http://programming.top54u.com/post/GridView-DropDownList-Update-SelectedValue-All-At-Once.aspx //http://www.codeproject.com/KB/webservices/db_values_dropdownlist.aspx DropDownList d = sender as DropDownList; if (d == null) return; //grab row that contains the drop down list GridViewRow row = (GridViewRow)d.NamingContainer; //pull data needed from the row (in this case we want the ID for the row) object ID = gridEntries.DataKeys[row.RowIndex].Values[tableID]; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[SiteSqlServer].ConnectionString); conn.Open(); SqlCommand c = new SqlCommand(UPDATE table SET value = @v WHERE tableID = @id conn); SqlParameter p = c.Parameters.Add(@id SqlDbType.Int); p.Value = Convert.ToInt32(ID); p = c.Parameters.Add(@v SqlDbType.Int); p.Value = Convert.ToInt32(d.SelectedValue); c.ExecuteNonQuery(); //databind the gridview to reflect new data. gridEntries.DataBind(); } more info