在rowdatabound事件gridview asp.net中绑定下拉列表 [英] Binding dropdownlist in rowdatabound event gridview asp.net

问题描述

我需要有关如何在Gridview中将数据隐藏到下拉列表的帮助？我将我的代码放在RowDataBound事件中。但是当我使用我的微软服务器2008作为我的数据库和存储过程时，我不知道如何在我的下拉列表中隐藏数据。 

I need help on how to blind data to dropdownlist in Gridview ? I am puting my code in RowDataBound event. But i don't know how to blind data in my dropdownlist when i using my microsoft server 2008 as my database and stored procedure. 

下面是我的gridview下拉列表代码  ;

< / asp：TemplateField>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;  < asp：TemplateField HeaderText =" Section">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < EditItemTemplate>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：DropDownList ID =" DropDownListSection" runat =" server">

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / asp：DropDownList>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / EditItemTemplate>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < ItemTemplate>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp：Label ID =" lblSection" RUNAT = QUOT;服务器" Text ='<％＃Bind（" SectionName"）％>'>< / asp：Label>

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / ItemTemplate>

</asp:TemplateField>
                   <asp:TemplateField HeaderText="Section">
                    <EditItemTemplate>
                        <asp:DropDownList ID="DropDownListSection" runat="server">
                        </asp:DropDownList>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="lblSection" runat="server" Text='<%# Bind ("SectionName") %>'></asp:Label>
                    </ItemTemplate>

下面是我的rowdatabound事件代码。

  protected void EmployeeGridView_RowDataBound（object sender，GridViewRowEventArgs e）

  &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; if（e.Row.RowType == DataControlRowType.DataRow）

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; {

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; SqlConnection con = new SqlConnection（@" User id = sa; Password = passw0rd; Server = L33524; Database = Test"）;



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; string strCommandText =" VRM.SELECT_SectionName";

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; SqlCommand cmd = new SqlCommand（strCommandText，con）;



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; cmd.CommandType = CommandType.StoredProcedure;



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; con.Open（）;



  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; DropDownList ddl =（DropDownList）e.Row.FindControl（" DropDownListSection"）;



//如何在这里失明？而上面的代码是正确的？因为我是存储过程的新手和C＃

  &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; }¥b $ b  &NBSP; &NBSP; &NBSP; }

  protected void EmployeeGridView_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                SqlConnection con = new SqlConnection(@"User id=sa;Password=passw0rd;Server=L33524;Database=Test");

                string strCommandText = "VRM.SELECT_SectionName";
                SqlCommand cmd = new SqlCommand(strCommandText, con);

                cmd.CommandType = CommandType.StoredProcedure;

                con.Open();

                DropDownList ddl = (DropDownList)e.Row.FindControl("DropDownListSection");

//how to blind here? and the code above is correct ? cause i am new to stored procedure and C#
            }
        }

最后这是我的存储过程

推荐答案

大家好我学会了如何对它进行数据处理。为什么我找不到下拉列表值呢？它给我null。

Hi guys i learn how to datablind it. buy why i cannot found the dropdownlist value ? It give me null.

错误消息： 对象引用未设置为对象的实例。

这篇关于在rowdatabound事件gridview asp.net中绑定下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！