sql代码里面加了And " & Filter & " 后提示列名 '_identify' 无效，不加的话正常显示。
请问老师什么原因，怎么改？
Dim xl As WinForm.ComboBox = e.Form.Controls("系列")
Dim wgh As WinForm.ComboBox = e.Form.Controls("物供号")
Dim dt1 As WinForm.DateTimePicker = e.Form.Controls("开始日期")
Dim dt2 As WinForm.DateTimePicker = e.Form.Controls("结束日期")
Dim filter As String = " _identify>0 "
If xl.Text > "" Then
filter= filter & " and 系列 = '" & xl.Text & "'"
End If
If wgh.Text > "" Then
filter= filter & " And 物供号 = '" & wgh.Text & "'"
End If
If dt1.Text > "" Then
filter= filter & " And 货期 >= '" & dt1.Text & "'"
End If
If dt2.Text > "" Then
filter= filter & " And 货期 <= '" & dt2.Text & "'"
End If
Dim t1 As WinForm.Table = e.Form.Controls("Table1")
Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.CommandText =
dt = cmd.ExecuteReader()
t1.Table.DataSource =dt
[此贴子已经被作者于2020/5/5 16:48:03编辑过]
加好友 
发短信
Post By：2020/5/5 10:00:00 [只看该作者]
