sql_variant is incompatible with xml

  • Thread starter Thread starter Dimitris Milonas
  • Start date Start date
D

Dimitris Milonas

Hello,

I have a table. One of it's fields is of Xml type. I'm using a Stored
Procedure in order to perform the update on this table. When I'm trying to
set the xml field in the "updating" event, I'm getting the following error
"operand type clash: sql_variant is incompatible with xml". The code that
I'm using in the "updating" event is something like:
e.Command.Parameters["@MyXmlField"].Value = null;
Does anybody know how to correct the error?

Regards
Dimitris
 
Hello,

I forgot to mention that I'm using a SqlDataSource to access the table and
the "updating" event belongs to the SqlDataSource.

Regards
Dimitris
 
Back
Top