C# listbox控件 显示数据表中的数据

Data
Source=;\.Open();
sqlcon
=
new
SqlConnection(",
sqlcon)SqlConnection
sqlcon;);
SqlDataAdapter
sqlada;
sqlcon.DisplayMember
=
"
sqlada
=
new
SqlDataAdapter(str;
string
str
=
"
很简单的一个绑定
;
listBox1..Fill(a).;press;goodsname1".希望能帮到你;;Initial
Catalog=HQZPOSDB;.DefaultView;
DataSet
a
=
new
DataSet();
sqlada.DataSource
=
a;User
ID=sa.Tables[0];Password=zenii"goodsname1".ValueMember
=
"select
goodsname1
from
goods";
listBox1;
listBox1.\

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;

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

cloudyy17

说的就可以

你把他说的写进事件里 他点100次 也是生成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;

你说的详细点，什么方面遇到问题了，要是都有问题那就很难帮你了