c# listbox控件读取出数据库中的数据。

2025-05-09 04:09:24
推荐回答(1个)
回答1:

SqlConnection sqlcon;
SqlDataAdapter sqlada;
sqlcon = new SqlConnection("Data Source=.\\press;Initial Catalog=HQZPOSDB;User ID=sa;Password=zenii");
sqlcon.Open();
string str = "select goodsname1 from goods";
sqlada = new SqlDataAdapter(str, sqlcon);
DataSet a = new DataSet();
sqlada.Fill(a);
listBox1.DisplayMember = "goodsname1";
listBox1.ValueMember = "goodsname1";
listBox1.DataSource = a.Tables[0].DefaultView;

很简单的一个绑定 ..希望能帮到你..