从数据库的数据表“用户”包含“姓名”,“密码”
让姓名显示在combobox中,用代码绑定:
Dim ds1 As New DataSet
Dim ds As New DataSet
ds = ExecuteSQL("SELECT 用户.* FROM 用户", ds1)
Me.Cboname.DataSource = ds.Tables(0)
Me.Cboname.DisplayMember = "用户.姓名"
con.Close() Public Function ExecuteSQL(ByVal SQL As String, ByVal ds As DataSet)
Public con As String = "Data Source=KXT-0204-03;Initial Catalog=csglxt;Integrated Security=True"
con.Open()
sda = New SqlDataAdapter(SQL, con)
sda.Fill(ds)
Return ds
End Function
运行的结果,在combobox中显示System.Data.DataRowView,而不是我想获取的值,求教!
让姓名显示在combobox中,用代码绑定:
Dim ds1 As New DataSet
Dim ds As New DataSet
ds = ExecuteSQL("SELECT 用户.* FROM 用户", ds1)
Me.Cboname.DataSource = ds.Tables(0)
Me.Cboname.DisplayMember = "用户.姓名"
con.Close() Public Function ExecuteSQL(ByVal SQL As String, ByVal ds As DataSet)
Public con As String = "Data Source=KXT-0204-03;Initial Catalog=csglxt;Integrated Security=True"
con.Open()
sda = New SqlDataAdapter(SQL, con)
sda.Fill(ds)
Return ds
End Function
运行的结果,在combobox中显示System.Data.DataRowView,而不是我想获取的值,求教!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货