主题：[求助]请BIN，有点甜，狐狸爸爸等专家指点:多条件查询Select

比如帮助里的Select("[金额] > 100")

想在这里增加查询条件,请问要怎么写??

 

 

Dim Cols1() As String = {"来源列一","来源列二","来源列三"}
Dim Cols2() As String = {"接收列一","接收列二","接收列三"}
For Each dr1 As DataRow In DataTables("表A").Select("[金额] > 100")
    Dim dr2 As DataRow = DataTables("表B").AddNew()
    For i As Integer = 0 To Cols1.Length -1
        dr2(Cols2(i)) = dr1(Cols1(i))
    Next
Next

顶上去...

请说明你要增加的条件是什么？

请看这儿http://www.foxtable.com/help/index.html?n=2481.htm

类似这样：

Select("[金额] > 100 and [数量] > 50 and [客户] = '张三'")

我的意思是'张三"一替换成文本框变量就报错

那就这样： Select("[金额] > 100 and [数量] > 50 and [客户] = '" & 变量 & "'")