老师:符合条件的记录找出来了,以集合形式将“业务编号”放在集合中,但如果用filter的话,只能显示最后一条记录,用 or 也不行,因为不知道有多少条记录。如何解决?
Case "景点"
Dim khmc3 As String = "%" & key.Value & "%"
Dim A2 As String = DataTables("行程安排表").GetComboListString("业务编号","景点1 like '" & khmc3 & "' Or 景点2 Like '" & khmc3 & "' Or 景点3 Like '" & khmc3 & "' Or 景点4 Like '" & khmc3 & "'")
MessageBox.Show(A2)
Dim Values1() As String
Values1 = A2.split("|")
For Index1 As Integer = 0 To Values1.Length - 1
MessageBox.Show(Values1(Index1))
' Tables("查询窗口_Table1").Filter = "业务编号 = '" & Values(Index) & "'"
Next