Example Analysis of vb.net Array participating in SQL query statement

This article mainly shows you the "vb.net array to participate in the sample analysis of SQL query sentences", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and learn the "vb.net array to participate in the example analysis of SQL query sentences" this article.

First define the array. I pass the value by session at the same time.

The copy code is as follows:

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

Then you can bring strruser into the sql statement to use.

These are all the contents of the article "sample Analysis of vb.net arrays participating in SQL query sentences". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!