在Gridview为DropDownlist添加数据源

我有一个包含5列的gridview，其中包含4个文本框和一个Dropdownlist.

现在，我想通过数据源或数据表加载我的下拉列表.

怎么做?甚至我也需要加载页脚...请帮助我

我试过...我的代码在下面

我的.aspx代码

I have an gridview with 5 columns with that 4 textbox and One Dropdownlist.

Now i want to load my dropdownlist through an datasource or datatable.

How to do that? Even i need to load my footer also...Please help me out

I tried...My code is below

My .aspx code

<asp:TemplateField HeaderText="Products">
                  <EditItemTemplate>
                  <asp:DropDownList ID="txt_grd_ProdName" runat="server" Width="95px" AutoPostBack="True" onselectedindexchanged="txt_grd_ProdName_SelectedIndexChanged" ><asp:ListItem>-Select-</asp:ListItem> </asp:DropDownList>
                  </EditItemTemplate>
                 <ItemTemplate>
                         <%#Eval("Prod_name") %>
                  </ItemTemplate>
                <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                <FooterTemplate>
                    <asp:DropDownList ID="Foot_Txt2" runat="server" Width="95px" AutoPostBack="True"><asp:ListItem>-Select-</asp:ListItem> </asp:DropDownList>
                </FooterTemplate>
                  </asp:TemplateField>

我的aspx.cs代码

My aspx.cs Code

protected void Grid_Purchase_RowDataBound(object sender, GridViewRowEventArgs e)
{
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            
                DropDownList dropdown = (DropDownList)e.Row.Cells[1].FindControl("txt_grd_ProdName");
                DataTable dt = new DataTable();
                dt = SQLobj.SQL_Adapter("Select Prod_name from ProductDetails");
                dropdown.DataSource = dt;
                dropdown.DataBind();
           
        }
}