Error:Object must implement IConvertible

  • Thread starter Thread starter Bob Frasca
  • Start date Start date
B

Bob Frasca

I'm trying to execute a datareader that calls a SQL Server stored procedure
and I get this error. I also tried loading a dataset using the database
adapter Fill method and I get the same error.

I have other ASPNET applications that do these things without a problem.

Anyone have any suggestions?
 
For the thread...if anyone's interested.

I resolved this problem. I was passing a parameter to my stored procedure.
I was incorrectly assigning the value to a "varchar" parameter.

Incorrect:

SqlCommandObject.Parameters("@Param").Value = txtTextBox

Correct:

SqlCommandObject.Parameters("@Param").Value = txtTextBox.Text

When it attempted to execute the datareader or the Fill method, SQL Server
(or was it ADONET) was attempting to convert a text box object to a varchar
instead of a text string object to a varchar.

An example of ambiguous naming conventions biting me in the ...
 
Back
Top