[Mono-dev] Error passing DBNull to SQLClient AddParameter method

T Senganal tsenganal at novell.com
Fri May 26 04:33:01 EDT 2006


> System.Data.SqlClient.SqlException: Disallowed implicit conversion 
> from data type sql_variant to data type varchar, table 'tablename', 
> column 'columnname'. Use the CONVERT function to run this query.

This is a bug.. fixed in svn (r61156)..

> The same thing i .NET works correctly, I'm doing something's wrong?.

well, its safer to set the datatype explicitly.. if u do not set the
datatype explicitly then
the datatype is inferred from the value assigned to the parameter and
that might not
always be the desired type..


More information about the Mono-devel-list mailing list