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.

 <TemplateField>
  <ItemTemplate>
  <asp:DropDownList ID="ddlSearchGroup" runat="server"  onselectedindexchanged="ddlSearchGroup_SelectedIndexChanged">
  </asp:DropDownList>
  </ItemTemplate>
 </TemplateField>

GridView Columns

EMPID Name Designation City
1 a s c 
2 b r g