vb.net 数组参与SQL语句的查询范例

首先定义数组，我是同事session传值的

dim struser as new list(of string)
struser = session("chooseuser")
strruser = ""

for a = 0 to struser.count - 1
if a = 0 then
strruser = "'" & struser.item(a).tostring.trim & "'"
else
strruser = strruser & " , " & "'" & struser.item(a).tostring.trim & "'"
end if
next

然后就可以吧strruser带入到sql语句中使用。