Error converting nvarchar to int 1

[MJV57]

I have the following code that executes a stored procedure and the parameter @customer is in the database as a varchar. Can anyone tell me why im getting the above stated error in this code. Thanks in advance.


SqlConnection conn = new SqlConnection("Data Source=server1;Initial Catalog=estimator;Integrated Security=True");
SqlCommand cmd = new SqlCommand("QuoteCreate", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@estnum", estno);
cmd.Parameters.AddWithValue("@quotenum", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@customer", SqlDbType.VarChar).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@stdrfq", SqlDbType.Int).Direction = ParameterDirection.Output;

 

[jmeckley]

this is the not problem. the exception stack trace will tell you where the error originated from (assuming you do not swallow errors.) if the exception is stating nvarchar as a problem, then the problem may be the stored proc. execute the code on the db server and see if any errors are thrown.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[MJV57]

The stored procedure works fine on when executed from the DB

 

[jmeckley]

post the stack trace and the code that uses the output parameters.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[chiph]

AddWithValue("@customer", SqlDbType.VarChar)

You're passing an integer (the value of the SqlDbType enum) to your database, which is expecting a string value. Try something like this:

AddWithValue("@customer", "Bill Gates")

MSDN docs:

http://msdn.microsoft.com/en-us/lib...ient.sqlparametercollection.addwithvalue.aspx

Note second parameter is the value, not the column type.

Chip H.



____________________________________________________________________
www.chipholland.com

 

[jmeckley]

Note second parameter is the value, not the column type.

this is why the error is occurring. the SqlDbType is an Enum which is an integer.

Jason Meckley
Programmer
Specialty Bakers, Inc.