Gridview templatefields databind

Question

I have a gridview with the following code:

<asp:TemplateField HeaderText="Column1">     
    <EditItemTemplate>         
        <asp:Label ID="Label1" runat="server" Text='<%# Bind("Column1") %>'></asp:Label  
    </EditItemTemplate>     
    <ItemTemplate>
        <asp:DropDownList ID="DropDownList1" runat="server" Width="125px">         
    </asp:DropDownList>     
    </ItemTemplate> 
    </asp:TemplateField>

I want to bind a sql statement to populate the dropdownlist...

select Column1 from Table1 would I do this through the code behind?

you can use the gridview_ItemDataBound Event to popupate the dropdownlist control — Nudier Mena, May 24 '12 at 03:07

score 0 · Answer 1 · answered May 23 '12 at 17:12

You can do it in the codebehind if you wish, or, if it applies to your situation, you can use the ObjectDataSource web server control.

More reading: ObjectDataSource Web Server Control Overview

Here's an example on how to bind the ObjectDataSource to your dropdown: asp.net ObjectDataSource example: how to populate DropDownList

Gridview templatefields databind

1 Answers1