make sure "empname" is indeed Employees的字段, the following works for me
SqlDataAdapter da = new SqlDataAdapter("select * from employees",
"server=localhost;database=northwind;uid=sa;pwd=;"); DataSet ds = new DataSet();
da.Fill(ds,"Employees"); listBox1 = new ListBox();
listBox1.Location = new Point(100,100);
listBox1.DataSource=ds.Tables["Employees"];
listBox1.ValueMember="EmployeeID";
listBox1.DisplayMember="LastName";
Controls.Add(listBox1);
SqlDataAdapter da = new SqlDataAdapter("select * from employees",
"server=localhost;database=northwind;uid=sa;pwd=;"); DataSet ds = new DataSet();
da.Fill(ds,"Employees"); listBox1 = new ListBox();
listBox1.Location = new Point(100,100);
listBox1.DataSource=ds.Tables["Employees"];
listBox1.ValueMember="EmployeeID";
listBox1.DisplayMember="LastName";
Controls.Add(listBox1);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货