c#combobox绑定mysql数据库_c# winform comboBox动态下拉列表，comboBox动态绑定数据库里的数据...

[public frm_Manage() { InitializeComponent(); string ConnectionString = "Data Source=dzjc_2005;user=kk;password=kk;";//写连接串

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();//关闭数据库连接

}

------------------------------------------------------------------------------------------------

或者[private void Form1_Load(object sender, EventArgs e) { string sqlString = SELECT DISTINCT process FROM monFile; DataSet ds = GetDat

下边是我用的方法

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

}

}

[想要形成这种效果的话，首先在数据里面建一张表create table treedata (id number, context varchar2(50), parentid number);id:当前的id，context当前节点的值文本，pare