"Additional information: Object must implement IConvertible."

[Guest]

HI

I am using Microsft Data Access building block

And i am getting following error

An unhandled exception of type 'System.InvalidCastException' occurred in eval.ex

"Additional information: Object must implement IConvertible.

my code look like thi

SqlParameter paramFName = new SqlParameter("@FNAME",SqlDbType.Char,25)
paramFName.Value = "A"

SqlParameter []parm = new SqlParameter[1] {paramFName };
SqlHelper.ExecuteNonQuery(this.connectionstring1, "AddPatient", parm)


thanks in advanc
-p

 

[Sahil Malik]

Sounds like a data type issue .. make sure that the SqlDbType you are
specifying matches Exactly what is in the database.

- Sahil Malik
Independent Consultant
You can reach me thru my blog at -
http://www.dotnetjunkies.com/weblog/sahilmalik/