如何在Gridview中为DropDownlist添加数据源 [英] How to Add DataSource for DropDownlist inside Gridview

问题描述

我有一个包含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();
           
        }
}

推荐答案

试试这个

try this

protected void grdDevelopment_RowDataBound(object sender, GridViewRowEventArgs e)
{
   if (grdDevelopment.EditIndex == e.Row.RowIndex && e.Row.RowType==DataControlRowType.DataRow)
   {
       DropDownList drpBuildServers = (DropDownList)e.Row.Cells[0].FindControl("Your DropDownName");
   }
}

您好，

您可以将数据源绑定到网格的行数据绑定事件上....正如我所看到的，您也只需绑定源，同时定义datatext和datavalue列.

试试吧

谢谢
sanjeev.

Hello,

you can bind the data source on row data bound event of grid.... as i can see you are just binding the source define datatext and datavalue columns as well.

try it out

thanks
sanjeev.

这篇关于如何在Gridview中为DropDownlist添加数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！