谁会.net 下拉列表动态绑定数据库

Question

谁会.net 下拉列表动态绑定数据库

Answer 1

楼主刚学的吧
-------------
将数据源赋给下拉框，再设下拉框的text和value属性就可以了，给个参考代码吧
datatable dt=你从数库里读到的数据集
dropdownlist.datasourse=dt;
dropdownlist.dataTextfiled=列名;
dropdownlist.dataValuefiled=列名;
dropdownlist.databind();
OK

Answer 2

如下DropDownList1.DataSource = dataSet.Tables["Table1"].DefaultView; DropDownList1.DataTextField = "ItemName"; //显示的字段DropDownList1.DataValueField = "id";  //绑定的字段DropDownList1.DataBind();

Answer 3

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    ListItem li = new ListItem();
                    li.Text = ds.Tables[0].Rows[i]["Name"].ToString();
                    li.Value = ds.Tables[0].Rows[i]["IID"].ToString();
                    ddl.Items.Add(li);
                }

Answer 4

  /// <summary>
        /// 绑定列表框 ListBox
        /// </summary>
        public static void PackDrlQuery(ListBox dr, DataView dv, string fieldtext, string fieldvalue, bool flag)
        {
            dr.DataSource = dv;
            dr.DataTextField = fieldtext;
            dr.DataValueField = fieldvalue;
            int count = dv.Count;
            dr.DataBind();
            if (flag)
            {
                dr.Items.Insert(0, "...");
                dr.Items[0].Value = "";
            }
        }        /// <summary>
        /// 绑定下拉框 DropDownList
        /// </summary>
        public static void PackDrlQuery(DropDownList dr, DataView dv, string fieldtext, string fieldvalue, bool flag)
        {
            dr.DataSource = dv;
            dr.DataTextField = fieldtext;
            dr.DataValueField = fieldvalue;
            int count = dv.Count;
            dr.DataBind();
            if (flag)
            {
                dr.Items.Insert(0, "...");
                dr.Items[0].Value = "";
            }
        }        /// <summary>
        /// 给下拉框赋值
        /// </summary>
        public static void DropDownSelect(DropDownList list, string val)
        {
            ListItem item = list.Items.FindByValue(val);
            if (item != null)
                item.Selected = true;
        }        /// <summary>
        /// 给radiolist赋值
        /// </summary>
        public static void DropDownSelect(RadioButtonList list, string val)
        {
            ListItem item = list.Items.FindByValue(val);
            if (item != null)
                item.Selected = true;
        }
        /// <summary>
        /// 绑定checkboxlist
        /// </summary>
        public static void PackCklQuery(CheckBoxList ckl, DataView dv, string fieldtext, string fieldvalue)
        {
            ckl.DataSource = dv;
            ckl.DataTextField = fieldtext;
            ckl.DataValueField = fieldvalue;
            ckl.DataBind();
        }
       
        /// <summary>
        /// 给checkboxlist赋值
        /// </summary>
        public static void DropDownCkl(CheckBoxList list, string [] val)
        {
            int count = val.Length;
            for (int i = 0; i < count; i++)
            {
                ListItem item = list.Items.FindByValue(val[i]);
                if (item != null)
                    item.Selected = true;
            }
        }