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