Web App DataGrid I need help pls

Question

Hello, maybe can someone to help me.
I have a datagrid in a WebApp which contains a dropdownlist named ddlGroup, and 3  bounded columns MinAge, MaxAge and Code.  In the datagrid I can Edit, Update, Delete and Add a new row. In Edit mode, Code is generated in accordance with ddlGroup, MinAge and MaxAge. For this I need an event or I don't know what to catch the moment when text is changed in MinAge, MaxAge  textboxes or the selectedvalue from ddlGroup.



Can someone help me, pls?
Thank you!

Answer 1

Bind the DropDownList like normal (set DataSourceID, DataTextField, DataValueField), and <%BIND%> 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