Bind column values to dropdownlist

Question

Hi I have a gridview and on top of that I have to add a dropdown list which will fetch column values. Designation is the column name. Also when a value is selected in the dropdownlist only the respective designation values should appear in the grid. Can anyone pls suggest me on this. GridView Columns EMPID Name Designation City 1 a s c 2 b r g

Hanook · Answer

http://www.aspsnippets.com/Articles/Populate-DropDownList-with-Selected-Value-in-EditItemTemplate-of-GridView-in-ASPNet.aspx

Hanook · Answer

For binding dropdownlist with database column cmd.CommandText =  Select * From GetUsersID ; cmd.Connection = conn; conn.Open(); DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); conn.Close(); DropDownList1.DataSource = dt; DropDownList1.DataTextField =  Name ; DropDownList1.DataValueField =  ID ; DropDownList1.DataBind(); References: For drop down list inside gridview control http://www.dotnetspider.com/resources/19586-dropdownlist-inside-Gridview.aspx http://csharpdotnetfreak.blogspot.com/2009/02/ajax-cascading-dropdownlist-database.html http://www.codeproject.com/Questions/475087/Howplustoplusbindplustheplusvaluesplusinplusdropdo