显示到DropDownlist

查询的时候，把Name就显示成你要的格式绑定

解决方案 »

  1.   

    在数据库里处理吧。类似 select (ID+NAME) as iname from table你懂得。。
      

  2.   

    value绑定id <option value="绑定id">绑定name</option>
      

  3.   

    Refer here:
    http://www.cnblogs.com/insus/articles/2075101.html
      

  4.   


    今天刚学习的 分享给你 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);
      

  5.   

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

  6.   

    帮你写了段源码，你应该改个数据库名称就能用了。这个可以封装成一个工具类。<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;
        }
     楼主加油！