具有多个条件的数据表选择SQL查询问题

Question

来自This question ，它的答案几乎就是我的答案。但我面临一些sql查询问题，我在VB中有以下语句

Dim results As DataRow() = table.Select("A = 'foo' AND B = 'bar' AND C = 'baz'")

我想放置 foo、bar 和 baz 在变量中并在上面的语句中使用这些变量。

Dim Varfoo As String = "foo"
Dim Varbar As String = "bar"
Dim Varbaz As String = "baz"

我设法在语句中获取一个变量

 Dim results As DataRow() = table.Select("A = " + Varfoo)

但是如何插入多个带有变量的排序表达式呢？

编辑:我用vikas的答案解决了这个问题，如下所示；

Dim results As DataRow() = table.Select("A = '" & Varfoo & "' And B = '" & Varbar & "' And C = '" & Varbaz & "'")

Answer 1

你试过吗

Dim results As DataRow() = table.Select("A = '" & Varfoo & "'")

已编辑

对于或运算

Dim results As DataRow() = table.Select("A = '" & Varfoo & "' OR B = '" & Varbar & "' OR C = '" & Varbaz & "'")

用于AND运算

Dim results As DataRow() = table.Select("A = '" & Varfoo & "' AND B = '" & Varbar & "' AND C = '" & Varbaz & "'")