Dim dt2 As DataTable
Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "S*elect [branch_name] As [仓库],[sup_name] As [供应商] From [t_pm_sheet_master] Left JOIN {t_bd_branch_info} ON {t_bd_branch_info}.[branch_no] = [t_pm_sheet_master].[branch_no] Left JOIN [t_bd_supcust_info] ON [t_bd_supcust_info].[supcust_no] =[t_pm_sheet_master].[supcust_no] Where [trans_no] in ('PI','RO')"
dt2 = cmd.ExecuteReader
Dim gys As WinForm.ComboBox = e.Form.Controls("供应商")
gys.ComboList = dt2.GetComboListString("供应商")
改成这样就可以了，反正就是SQLGetComboListString不行，我搜论坛也挺多人反馈的，还好我没用两个，全部手动改了。
[此贴子已经被作者于2022/8/29 14:24:50编辑过]
加好友 
发短信
Post By：2022/8/29 11:34:00 [只看该作者]
