bind data to ddl gridview

Question

how to bind data into dropdownlist which is inside of the gridview and also i want bind from another table

Abhay Shanker · Answer

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 ; } }

Satyapriya Nayak · Answer

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