How to add list of items in dropdownlist in grid view any one please help me

See more:

C#

ASP.NET

Hi i have to add one dropdownlist in grid view in which i have to show some list of items on edit mode how to do this any please help me here is my code.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowcancelingEdit" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="userid" OnRowEditing="GridView1_RowEditing" >
           <Columns>
               <asp:BoundField DataField="userid" HeaderText="userid" ReadOnly="true" />
               <asp:TemplateField HeaderText="name">
               <ItemTemplate>
           <%# Eval("name")%>
         </ItemTemplate>
         <EditItemTemplate>
           <asp:TextBox runat="server" ID="txtname" Text='<%# Bind("name")%>' />
         </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="age">
               <ItemTemplate>
             <%# Eval("age")%>
         </ItemTemplate>
         <EditItemTemplate>
             <asp:TextBox runat="server" ID="txtage" Text='<%# Bind("age")%>' />
         </EditItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="City" SortExpression="City">
                   <EditItemTemplate>
                       <asp:DropDownList ID="DropDownList1" runat="server"
                           DataSourceID="SqlDataSource2" DataTextField="City" DataValueField="City"
                           SelectedValue='<%# Bind("city") %>' >
                       </asp:DropDownList>
                   </EditItemTemplate>
                   <ItemTemplate>
                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("city") %>'></asp:Label>
                   </ItemTemplate>
               </asp:TemplateField>
               <asp:CommandField ShowEditButton="True" ButtonType="Button" />
           </Columns>
       </asp:GridView>

       <br />

   </div>
   <asp:SqlDataSource ID="SqlDataSource2" runat="server"
       ConnectionString="Server=ALOK\SQLEXPRESS; Database=Employee; uid=sa; pwd=1234;"
       SelectCommand="SELECT DISTINCT [City] FROM [employ]"></asp:SqlDataSource>
   <br />
   <br />
   </form>