How to set unnamed SQL parameters in SqlCommand

Question

If I add unnamed parameters to my SqlCommand , how to set parameter values ​​to SqlCommand?

I have no problem when I use named parameters where I can just do SqlCommand.Parameters.AddWithValue() .

Example:

 Select * from sometable where SomeValue=? and AnotherValue=? 

Answer 1

With ADO.NET vs SQL Server, Can't You Use Those ? for parameters - you always need to use the @paramName approach.

? for unnamed parameters is ODBC "left", but not supported in ADO.NET when using SQL Server (not sure about MS-Access)

Answer 2

Use ADODBConnection and ADODBCommand instead of SQL versions.