How to set unnamed SQL parameters in SqlCommand

Question

If I add unnamed parameters to my SqlCommand, how do I set the parameter values, on the SqlCommand?

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

Example:

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

Ugh, that is unfortunate. I guess I'll have to name them, then. You should make an answer :) — Nicolai
– Nicolai, Commented Jan 18, 2012 at 11:52

marc_s · Accepted Answer · 2012-01-18 11:54:34Z

4

With ADO.NET against SQL Server, you cannot use those ? for parameters - you always have to use @paramName approach.

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

answered Jan 18, 2012 at 11:54

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oleg Dok · Accepted Answer · 2012-01-18 11:13:04Z

0

Use ADODBConnection and ADODBCommand instead of SQL versions.

answered Jan 18, 2012 at 11:13

Oleg Dok

21.9k4 gold badges48 silver badges55 bronze badges