HI,
Is it possible to use "IN" operator in OleDbCommand.Parameters.AddWithValue ?
I have search online but find no solution on using "IN" operator in OleDbCommand.Parameters.AddWithValue .

My code is as below:
Dim conn As New OleDbConnection
Dim cmd As New OleDbCommand
Dim Adapter As New OleDb.OleDbDataAdapter
Dim strSQL As String
Dim dsDoc As New DataSet


conn.ConnectionString = ConstructConnString()
conn.Open()
cmd.Connection = conn

strSQL = " select * from [Doc] where DocNo in (@Doc) "
cmd.CommandText = strSQL
cmd.Parameters.AddWithValue("@Doc", " TR201107070001 ,TR201107070002")

Adapter.SelectCommand = cmd
Adapter.Fill(dsDoc)


Where there is 2 Document No inside parameter @Doc , i can't get any of them. When there is only 1 Document No, then it is ok.

Is it possible to use "IN" operator together with OleDbCommand.Parameters.AddWithValue ?