多条件查询解决方法

多条件查询
vb中 怎么把下面的查询 变成一个查询 或者用for 语句 也行 只要并到一起就行


sql = "select * from A线表_temp where 姓名 like'" & List2.List(0) & "'"
sql = "select * from A线表_temp where 姓名 like'" & List2.List(1) & "'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(2) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(3) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(4) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(5) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(6) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(7) & "%'"
sql = "select * from A线表_temp where 姓名 like'%" & List2.List(8) & "%'"
 

[解决办法]
。。。。。。。。。。。。LZ加油看好你，这个不难 
stringBuilder sql = new stringBuilder ();
sql.Append(string.Format("select * from A线表_temp where 姓名 like '&{0}&' ",List2.List(i)));
sql.Append("\n")


放到你循环里面，最后执行 sql

[解决办法]
仅供参考

VB.NET code

dim sql = "select * from A线表_temp where "for i as integer = 0 to 8if i = 0 thensql = sql & "姓名 like'" & List2.List(i) & "'"elsesql = sql & " or 姓名 like'" & List2.List(i) & "'"end ifnext
[解决办法]
那个是vb.net的用法，你vb6分开吧

dim i as integer = 0

for i to 8  
...
next
[解决办法]
sql = "select * from A线表_temp where 姓名 like '" & List2.List(0) & "' or 姓名 like '" & List2.List(1) & "'  or 姓名 like '" & List2.List(2) & "'  or 姓名 like '" & List2.List(3) & "' "

不过你的like ，似乎应该要加百分号。不然就相当于=了.