SqlClient CE parameters

[Rob Gravereaux]

I coded a small CE test app (C#, .Net 2003) that retrieves data from SQL
Server using the SQLClient objects. Retrieving data with a SqlDataAdapter
works fine. SqlCommand objects work OK without parameters, but when I add a
parameter and try to execute a SqlCommand, I get an error
'System.Data.SqlClient.SqlError: Line 1: Incorrect syntax near
'spRetrieveUser2''

Has anyone run into this? I can't find any good documentation on using
parameters for SQLClient for CE.

Thanks.

--
______________________________
Rob Gravereaux
Principle Software Developer
Glen Road Systems, Inc.
http://www.grsinc.com

 

[Rob Gravereaux]

....Nevermind

I was executing a stored procedure and forgot to set cmd.CommandType =
CommandType.StoredProcedure.