如何设置 cmb.DataSource = "dt.name" 这段。
dt.=name 是空白，直接使用dt 又不行，必须要一个string
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.Com mandText = "SELE CT UserID,UserName From {st_user}"
dt = cmd.ExecuteReader
dt.load
'msgbox(dt.name)
Dim cmb As WinForm.ComboBox = e.Form.Controls("ComboBox1")
cmb.DisplayMember = "UserName" '设置显示列
cmb.ValueMember = "Userid" '设置取值列
cmb.DataSource = "dt.name" '表项目来自于客户表
谢谢，加为外部表 就可以使用了。但输入UserName，Userid的任何记录，都不能自动填充，必须自己完全输入
并且DataSort也没有效果
Dim cmb As WinForm.ComboBox = e.Form.Controls("ComboBox1")
cmb.DisplayMember = "UserName" '设置显示列
cmb.ValueMember = "Userid" '设置取值列
cmb.DataSort = "UserName"
cmb.DataSource = "st_user_profile" '表项目来自于客户表
cmb.AutoComplete = True
[此贴子已经被作者于2023/9/11 11:48:37编辑过]
调换下位置
Dim cmb As WinForm.ComboBox = e.Form.Controls("ComboBox1")
cmb.AutoComplete = True
cmb.DisplayMember = "UserName" '设置显示列
cmb.ValueMember = "Userid" '设置取值列
cmb.DataSort = "UserName"
cmb.DataSource = "st_user_profile" '表项目来自于客户表
Dim cmb As WinForm.ComboBox = e.Form.Controls("ComboBox1")
cmb.AutoComplete = True
cmb.DataSort = "UserName"
cmb.DisplayMember = "UserName" '设置显示列
cmb.ValueMember = "Userid" '设置取值列
cmb.DataSource = "st_user_profile" '表项目来自于客户表
DataSort也没有效果，我换成Userid 也没有用