C#Combobox 绑定数据库可以输入想要的非数据库内容

最新推荐文章于 2021-12-04 09:07:53 发布

guoyong4321

最新推荐文章于 2021-12-04 09:07:53 发布

阅读量991

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/guoyong4321/article/details/7097974

版权

using System.Collections;

        /// <summary>
        /// 获取菜品
        /// </summary>
        public void GetFood()
        {
            DataTable dtRole = SqlDBHelper.GetDataTable("SELECT * FROM   餐牌");
            ArrayList roleList = new ArrayList();
            roleList.Add(new DictionaryEntry("0", ""));//输入空格

            foreach (DataRow dr in dtRole.Rows)
            {
                roleList.Add(new DictionaryEntry(dr["DetailFoodId"].ToString(), dr["项目名称"].ToString()));
            }

ComboxBindSource(this.cmbFoodName, roleList);
}

        public static void ComboxBindSource(ComboBox cb, ArrayList arList)
        {
            cb.DataSource = arList;
            cb.DisplayMember = "value";
            cb.ValueMember = "key";
        }