ComboBox 绑定的问题

[czh402]

我怎么将 employee表中的字段name和combobox1绑定起来，运行后 combobox1 里面内容还是空。下面的代码是不是有问题


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim mydataset As DataSet = New DataSet()

Dim conn As New System.Data.SqlClient.SqlConnection
Dim cnstr As String = "Data Source=(local);Initial Catalog=huamn;Integrated Security=True,use id=sa,pwd="
conn.ConnectionString = cnstr

Dim comm As New System.Data.SqlClient.SqlCommand()
comm.CommandText = "SELECT * FROM employee"
comm.Connection = conn

Dim dataap As New System.Data.SqlClient.SqlDataAdapter
dataap.SelectCommand = comm

dataap.Fill(mydataset)

ComboBox1.DataSource = mydataset.Tables("employee")
ComboBox1.DisplayMember = "name"
End Sub

[万小萌]

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim mydataset As DataSet = New DataSet()

Dim conn As New System.Data.SqlClient.SqlConnection
Dim cnstr As String = "Data Source=(local);Initial Catalog=huamn;Integrated Security=True,use id=sa,pwd="
conn.ConnectionString = cnstr

Dim comm As New System.Data.SqlClient.SqlCommand()
comm.CommandText = "SELECT * FROM employee"
comm.Connection = conn

Dim dataap As New System.Data.SqlClient.SqlDataAdapter
dataap.SelectCommand = comm

dataap.Fill(mydataset)

ComboBox1.DataSource = mydataset.Tables("employee")
ComboBox1.DisplayMember = "name"
End Sub

错误很显然，我不懂vb，但是问题一定是出在
dataap.Fill(mydataset)

ComboBox1.DataSource = mydataset.Tables("employee")
这两个地方，你fill的时候没有指定表名，而你绑定的时候不是用的第0个表而是用表名表示的
讲dataap.Fill(mydataset)，改为dataap.Fill(mydataset,"employee")，或者将ComboBox1.DataSource = mydataset.Tables("employee") 改为ComboBox1.DataSource = mydataset.Tables(0)，思路是这样的但是我vb不熟，我想应该大致是对的，赫赫

[rangeon]

不精通VB.NET，不过感觉好像最后少了一句Combobox1.DataBind()

[czh402]

谢谢 fly_goldfish

已经好了，谢谢~！~！

[hmilj245216]

dataap.Fill(mydataset,"employee")