ASP.NET

<asp:GridView ID="grd" runat="server" OnRowDataBound="grd_RowDataBound">           <Columns>        <asp:TemplateField HeaderText="names">             <ItemTemplate>            <asp:DropDownList ID="name" runat="server" OnSelectedIndexChanged="onSelectChangeddl"></asp:DropDownList>          </ItemTemplate>          </asp:TemplateField>          <asp:TemplateField HeaderText="age">           <ItemTemplate>          <asp:DropDownList ID="age" runat="server" AutoPostBack="true">           </asp:DropDownList>            </ItemTemplate>          </asp:TemplateField>    </Columns>          </asp:GridView>

foreach (GridViewRow row in grd.Rows)   {   DropDownList ddl1 = (DropDownList)row.FindControl("name");   DropDownList ddl = (DropDownList)row.FindControl("age");       if (ddl.SelectedValue.ToString() != "---Select---")     {     }     else          {     ddl.Items.Clear();     }           SqlCommand SPComm = new SqlCommand("someStoredProcedure", myConn);     SPComm.CommandType = CommandType.StoredProcedure;     SqlParameter param = SPComm.Parameters.Add("@something", SqlDbType.NVarChar, 50);     param.Value = something;     dr = SPComm.ExecuteReader();  //dr is sqlDataReader     int i = 0;     while (dr.Read())     {     ddl.Items.Insert(i, dr.GetString(0));     }     dr.Close();     ddl.Items.Insert(0, "---Select---");     }