Dim dt1 As DataTable = DataTables("工作分析表")
Dim List_sjgw As new List (of String)
Dim name As String = user.Name
Dim cmd As new SQLCommand
cmd.C
cmd.CommandText = "sele ct [_identify],上级岗位名称,姓名,岗位名称 from 组织架构 where 姓名 = '" & name & "'"
Dim dt As DataTable = cmd.ExecuteReader()
For Each dr As DataRow In dt.DataRows
List_sjgw.add(dr("上级岗位名称"))
Next
Dim filter As String = "1=1"
For Each s As String In List_sjgw
filter = filter & " or " & s & " like '%'+ [岗位名称] +'%'"
Next
msgbox(filter)
dt1.LoadFilter = filter
dt1.load
出现如下错误：
.NET Framework 版本：4.0.30319.42000
Foxtable 版本：2021.12.30.1
错误所在事件：加载[工作分析表]失败!
详细错误信息：
列名 '总经理_副总经理_检测中心总监_力学室主任' 无效。
列名 '总经理_副总经理_检测中心总监' 无效。
加好友 
发短信
Post By：2022/1/4 9:23:00 [显示全部帖子]
