Question Parameterized Queries in VS 2008

[servantofone]

I'm writing a parameterized query in my Table Adapter using the query builder in VS 2008 Pro. Because I'm querying an Access database, I understand I need to use question marks to identify the parameters. What follows is what I have written so far.

SELECT DISTINCT UM_Name, UM_ID
FROM         tblHierarchy
WHERE     (? IS NULL) OR
                      (OM_ID = ?)
ORDER BY UM_Name

I'd like to check for null values; however, I don't want to repeat the parameters when I am passing them into the query. Is there any way to identify the parameters with names as is normal (i.e. @parameter1)? Or will I need to pass each parameter twice?

Thanks!

 

[jmcilhinney]

will I need to pass each parameter twice?

Bingo! .

 

[TyB]

Try this

cmd.Parameters.Add(New OleDbParameter("?", Value))
cmd.Parameters.Add(New OleDbParameter("?", Value))

Ty