Question

C#中ListBox控件如何实时显示ACCESS数据库表中某个字段对应的所有记录值！！！求解呀！！！

Answer 1

//通过listbox1.DataSource
来初始化其Items中的值
DataTable
table
=
GetTable();//
这里省略了从Access中获取表数据的代码
listBox1.DataSource
=
table;
listBox1.DisplayMember
=
"要显示的字段名称";

Answer 2

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;
很简单的一个绑定
..希望能帮到你..