how to bind data from database table to a dropdownlist nested in a gridview

[sudha k]

how to bind data from database table to a dropdownlist nested in a gridview

[Utkarsh Sri]

//GridView  event
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //finding dropdown of current row by dropdown id
         DropDownList myDropDown= e.Row.FindControl("dropdownId") as DropDownList;
 
         myDropDown.DataTextField = "countryName";
         myDropDown.DataValueField = "countryId";
 
         myDropDown.DataSource = GetCountryList("Asia");
 
         myDropDown.DataBind();
    }