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