Multi-parameter stored procedure (query in Access)

[VictorCorey]

Is it possible to use a multi-parameter query in .NET

Here's the method
Public Function SearchCatalog(B yVal searchString As String, ByVal allWords As String) As OleDbDataReade

' Create the connection objec
Dim connection As New OleDbConnection (connectionStri ng
Dim command As New OleDbComman

' We guard agains bogus values here - if we receive anythin
' different than "TRUE" we assume it's "FALSE
If allWords.ToUppe r = "TRUE" The
' Create and initialize the command object and search all word
command.Command Text = "SearchCatalogA llWords
command.Connect ion = connectio
command.Command Type = CommandType.Sto redProcedur
Els
' Create and initialize the command object and search any word
command.Command Text = "SearchCatalogA nyWords
command.Connect ion = connectio
command.Command Type = CommandType.Sto redProcedur
End I

' We eliminate separation character
searchString = searchString.Re place(",", " "
searchString = searchString.Re place(";", " "
searchString = searchString.Re place(".", " "

' We create an array which contains the word
Dim words() As String = Split(searchStr ing, " "

' wordsCount contains the total number of word
Dim wordsCount As Integer = words.Lengt
' index is used to parse the list of word
Dim index As Integer =
' this will store the total number of added words
Dim addedWords As Integer =

' We allow a maximum of 5 word
While addedWords < 5 And index <
' We add the @searchWord parameters her
If addedWords < wordsCount The
addedWords +=
' Add an input parameter and supply a value for i
command.Paramet ers.Add("@searc hWord" + addedWords.ToSt ring, words(index)
Els
addedWords +=
' Add a blank input paramete
command.Paramet ers.Add("@searc hWord" + addedWords.ToSt ring, ""
End I
index +=
End Whil
' Open the connectio
connection.Open (

' Return a SqlDataReader to the calling functio
Return command.Execute Reader(CommandB ehavior.CloseCo nnection
End Functio

Here is the query
SELECT Product.Product ID, Product.Name, Product.Descrip tion, Product.SKU, Product.Price, Product.ImagePa t
FROM Produc
WHERE (((Product.Name ) Like "*"+[@searchWord1]+"*")) OR (((Product.Desc ription) Like "*"+[@searchWord1]+"*"))AND (((Product.Name ) Like "*"+[@searchWord2]+"*")) OR (((Product.Desc ription) Like "*"+[@searchWord2]+"*")) AND (((Product.Name ) Like "*"+[@searchWord3]+"*")) OR (((Product.Desc ription) Like "*"+[@searchWord3]+"*")) AND (((Product.Name ) Like "*"+[@searchWord4]+"*")) OR (((Product.Desc ription) Like "*"+[@searchWord4]+"*")) AND (((Product.Name ) Like "*"+[@searchWord5]+"*")) OR (((Product.Desc ription) Like "*"+[@searchWord5]+"*"))