c# winform comboBox动态下拉列表，comboBox动态绑定数据库里的数据
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.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.ToString());//循环读区数据 } }
黑色头发 http://heisetoufa.iteye.com
页:
[1]