- 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 = "Da
ta 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());//循环读区数据
- }
- }