显示到DropDownlist

Jack123 2014-05-09 09:47:54

表里有ID，Name，如何显示到DropDownlist ？

DataValueField 对应ID ， DataTextField 如何显示成：Name---ID ( 如：张三---1)

...全文

630 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

梦落凡尘 2014-05-09

打赏
举报

帮你写了段源码，你应该改个数据库名称就能用了。这个可以封装成一个工具类。


<head runat="server">
    <title></title>
    <style type="text/css">
        .box
        {
            border: 1px solid #C0C0C0;
            width: 182px;
            height: 19px;
            clip: rect(0px,181px,18px,0px);
            overflow: hidden;
        }
        .box2
        {
            border: 1px solid #F4F4F4;
            width: 180px;
            height: 17px;
            clip: rect(0px,179px,16px,0px);
            overflow: hidden;
        }
        select.nice
        {
            position: relative;
            left: -2px;
            top: -2px;
            font-size: 12px;
            width: 183px;
            line-height: 14px;
            border: 0px;
            color: #414141;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <span class="box"><span class="box2">
            <asp:DropDownList ID="myDropDownList" runat="server" CssClass="nice" DataTextField="name"
                DataValueField="id" Width="160" Font-Size="16">
            </asp:DropDownList>
        </span></span>
    </div>
    </form>
</body>

//----------------------------------------------------------------后台代码


 protected void Page_Load(object sender, EventArgs e)
    {
        AddCombo(myDropDownList, GetID("表名"), GetName("表名"));
    }

    private void AddCombo(DropDownList dropList, List<string> KindNameList, List<string> KindIDList)
    {

        for (int i = 0; i < KindNameList.Count; i++)
        {
            ListItem item = new ListItem();
            item.Text = KindNameList[i];
            item.Value = KindIDList[i];
            dropList.Items.Add(item);
        }
    }

    /// <summary>
    /// 获取ID
    /// </summary>
    /// <param name="tableName"></param>
    /// <returns></returns>
    public static List<string> GetID(string tableName)
    {
        List<string> listInfo = new List<string>();

        string connectionString = ConfigurationManager.ConnectionStrings["conn"].ToString();
        SqlHelper.SetConnSting(connectionString);

        string strSQL = "SELECT ID FROM " + tableName + " ORDER BY ID";

        SqlDataReader reader = SqlHelper.ExecuteReader(connectionString, System.Data.CommandType.Text, strSQL);

        while (reader.Read())
        {
            string typename = reader["ID"].ToString();
            listInfo.Add(typename);
        }
        reader.Close();
        reader.Dispose();

        return listInfo;
    }
    /// <summary>
    /// 获取NAME
    /// </summary>
    /// <param name="tableName"></param>
    /// <returns></returns>
    public static List<string> GetName(string tableName)
    {
        List<string> listInfo = new List<string>();

        string connectionString = ConfigurationManager.ConnectionStrings["conn"].ToString();
        SqlHelper.SetConnSting(connectionString);

        string strSQL = "SELECT name FROM " + tableName + " ORDER BY ID";

        SqlDataReader reader = SqlHelper.ExecuteReader(connectionString, System.Data.CommandType.Text, strSQL);

        while (reader.Read())
        {
            string typename = reader["name"].ToString();
            listInfo.Add(typename);
        }
        reader.Close();
        reader.Dispose();

        return listInfo;
    }

楼主加油！

by_封爱 2014-05-09

打赏
举报

http://bbs.csdn.net/topics/390781201 原帖..举一反三

by_封爱 2014-05-09

打赏
举报

今天刚学习的分享给你


 var dt = new DataTable();
 dt.Columns.Add("id", typeof(int));
 dt.Columns.Add("name", typeof(string));
 dt.Rows.Add(1, "张三");
 dt.Rows.Add(2, "李四");
 var items = dt.AsEnumerable().Select(d => new ListItem(d.Field<string>("name") +"-"+ d.Field<int>("id").ToString())).ToArray();
  d1.Items.AddRange(items);