CombOX控件与数据库中的数据绑定与读取-C#编程

本篇只给出CombOX控件的绑定函数，数据库的连接和读取不在讨论范围，看代码：

        #region tb_Industry从数据库表中读取记录填冲CombOX控件
        public void filltb_Industry(object comb)
        {
            tbDai = new tbDaiConnection(); //实例化一个数据库连接类
            oledCon = tbDai.OledCon(); //打开一个数据库连接
            oledDDa = new OleDbDataAdapter("select Caption from tb_Industry ", oledCon);
            ds = new DataSet();
            oledDDa.Fill(ds);  // 数据库查询填充等
            if (comb.GetType().ToString() == "System.Windows.Forms.ComboBox")
            {
                System.Windows.Forms.ComboBox cmb = (System.Windows.Forms.ComboBox)comb;
                cmb.DataSource = ds.Tables[0].DefaultView;
                cmb.DisplayMember = "username";//显示的值
                cmb.ValueMember = "userID";//传递的值，没有默认为cmb.DisplayMember的值
            }
            oledCon.Close();
        }
        #endregion

------------------------------------
tbClass.khState = cmbkhState.SelectedIndex;//CombOX控件值的获取

完毕，很简单的，原创文章转载注明来源：站长无忧

标签(Tag):