bind data to ddl gridview

Try as below:-

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

//Find the DropDownList in the Row

DropDownList ddlCountries = (e.Row.FindControl("ddlCountries") as DropDownList);

ddlCountries.DataSource = GetData("SELECT DISTINCT Country FROM Customers");

ddlCountries.DataTextField = "Country";

ddlCountries.DataValueField = "Country";

ddlCountries.DataBind();

//Add Default Item in the DropDownList

ddlCountries.Items.Insert(0, new ListItem("Please select"));

//Select the Country of Customer in DropDownList

string country = (e.Row.FindControl("lblCountry") as Label).Text;

ddlCountries.Items.FindByValue(country).Selected = true;

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhay Shanker12y ago
Try as below:-

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        //Find the DropDownList in the Row
        DropDownList ddlCountries = (e.Row.FindControl("ddlCountries") as DropDownList);
        ddlCountries.DataSource = GetData("SELECT DISTINCT Country FROM Customers");
        ddlCountries.DataTextField = "Country";
        ddlCountries.DataValueField = "Country";
        ddlCountries.DataBind();

        //Add Default Item in the DropDownList
        ddlCountries.Items.Insert(0, new ListItem("Please select"));

        //Select the Country of Customer in DropDownList
        string country = (e.Row.FindControl("lblCountry") as Label).Text;
        ddlCountries.Items.FindByValue(country).Selected = true;
    }
}
0
Satyapriya Nayak12y ago
http://www.aspdotnet-suresh.com/2012/05/bind-data-to-dropdownlist-in-gridview.html
http://www.aspsnippets.com/Articles/How-to-bind-data-to-DropDownList-in-GridView-in-ASPNet.aspx
0