当前位置:编程学习 > C#/ASP.NET >>

用DataList显示数据库表的字段名

    /// <summary>
    /// 返回表名下所有字段
    /// </summary>
    /// <param name="SqlConnectionStr"></param>
    /// <returns></returns>
    public static void GetAllColumn(string source, string tableName,DataList dl)
    {
        List<string> list = new List<string>();
        //打开连接
        SqlConnection sqlcn = new SqlConnection(source);
        sqlcn.Open();
        SqlCommand sqlcmd = new SqlCommand("SELECT TOP 1 * FROM [" + tableName + "]", sqlcn);
        SqlDataReader dr = sqlcmd.ExecuteReader();
        for (int i = 0; i < dr.FieldCount; i++)
        {
            list.Add(dr.GetName(i));//数据库的字段名
        }
        dl.DataSource = list;
        dl.DataBind();
        sqlcn.Close();
    }

<asp:DataList ID="DataList2" runat="server" Width="97px">
                <ItemTemplate>
                    <table border="1" cellpadding="0" cellspacing="0">
                        <tr>
                            <td style="width: 100px; height: 19px">
                                <asp:CheckBox ID="CheckBox1" runat="server" /></td>
                            <td style="width: 100px; height: 19px">
                                <asp:Label ID="Label1" runat="server" Text='<%#Eval("怎么绑定") %>'></asp:Label></td>
                        </tr>
                    </table>
                </ItemTemplate>
            </asp:DataList>

我在DataList用Label显示数据库某一张表下的所有字段的名称(比如在页面上显示"name",而不是字段名对应的值。)。望各位朋友指点! --------------------编程问答-------------------- 显示表的名称,你在DataList的HeaderTemplate中设置就是了。
--------------------编程问答--------------------

<asp:DataList ID="DataList2" runat="server" Width="97px">
  <HeaderTemplate>
           <table border="1" cellpadding="0" cellspacing="0">
               <tr>
                    <td>选择</td>
                    <td>字段名称</td>
                </tr>
  </HeaderTemplate>
  <ItemTemplate>
               <tr>
                     <td style="width: 100px; height: 19px">
                          <asp:CheckBox ID="CheckBox1" runat="server" />
                    </td>
                    <td style="width: 100px; height: 19px">
                           <asp:Label ID="Label1" runat="server" Text='<%#Eval("怎么绑定") %>'></asp:Label>            
                   </td>
              </tr>
     </ItemTemplate>
     <FooterTemplate>
            </table>
      </FooterTemplate>
  </asp:DataList>
--------------------编程问答--------------------

<asp:DataList ID="DataList2" runat="server" Width="97px">
  <HeaderTemplate>
           <table border="1" cellpadding="0" cellspacing="0">
               <tr>
                    <td>选择</td>
                    <td>字段名称</td>
                </tr>
  </HeaderTemplate>
  <ItemTemplate>
               <tr>
                     <td style="width: 100px; height: 19px">
                          <asp:CheckBox ID="CheckBox1" runat="server" />
                    </td>
                    <td style="width: 100px; height: 19px">
                           <asp:Label ID="Label1" runat="server" Text='<%#Eval("name") %>'></asp:Label>            //这里的name就是你数据库中表的字段名称
                   </td>
              </tr>
     </ItemTemplate>
     <FooterTemplate>
            </table>
      </FooterTemplate>
  </asp:DataList>
--------------------编程问答-------------------- <%#Container.DataItem  %> --------------------编程问答-------------------- 楼上说的好像都不是,下面是效果图:
--------------------编程问答-------------------- 不会上图的话,请参考:
http://topic.csdn.net/u/20110903/18/7b87292a-527d-41f1-af5e-98401cd82d16.html --------------------编程问答-------------------- List是没有字段名称的,不能使用<%#Eval("怎么绑定") %>,只能使用<%#Container.DataItem %>
补充:.NET技术 ,  ASP.NET
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,