# winform comboBox动态下拉列表,comboBox动态绑定数据库里的数据
来源:互联网 发布:少见成语知乎 编辑:程序博客网 时间:2024/05/17 23:03
- public void InsertComShopID(ComboBox cb)
- {
- cb.Items.Clear();//清空ComBox
- SqlCommand cmd = new SqlCommand("select name from shop",DB.Getcon());//构造连接字符串并切打开数据库连接
- SqlDataReader sdr =cmd.ExecuteReader();
- while (sdr.Read())
- {
- cb.Items.Add(sdr[0].ToString());//循环读取数据
- }//end block while
-
- sdr.Close();// 关闭数据集
- DB.GetColse();//关闭数据库连接
- }
- string ConnectionString = "Data Source=dzjc_2005;user=kk;password=kk;";//写连接串
- OracleConnection conn = new OracleConnection(ConnectionString);//创建一个新连接
-
- conn.Open();
- OracleCommand cmd = conn.CreateCommand();
- cmd.CommandText = "SELECT rname,did,rchannel FROM nwvideo.n_road ";//在这儿写sql语句
- OracleDataReader dr = cmd.ExecuteReader();//创建一个OracleDateReader对象
-
- if (dr.HasRows)
- {
- cmbChannelSelect.Items.Clear();//清空ComBox
- while (dr.Read())
- {
- cmbChannelSelect.Items.Add(dr[2].ToString());//循环读区数据
-
- }
- }