Alex,

OK, I am getting beyond compiler errors on the parameter add now (and am not having to declare a data type in the SqlParameter object), but am getting System.Reflection errors now when running the query.

"No mapping exists from object type System.Reflection.RuntimeMethodInfo to a known managed provider native type."

but I think I will consider that progress. *smile* I need to head home and will tackle this new error tomorrow.

If I can get parameters working, I have no problem with the @ vs ? differences, and even if I did, Michel's idea abstracts that too.

Thanks to everyone for their help and patience...

Thanks,
JoeK

>Joe AddWithValue is new on .NET 2.0 and it works on any dataprovider i.e. odbc, oledb,sqlserver, SqlCE and Oracle also, If your using .NET 1.1 then you can call just the parameters.Add(paramname, value)
>
>>Alex,
>>
>>FYI, I am not using the ODBC command/parameter objects. I see in the .NET documentation that AddWithValue is only for OdbcParameter class. I am using OleDbCommand and SQLCommand, so I need something that works with those.
>>
>>Thanks,
>>JoeK
>>