sql_variant is incompatible with xml

[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

 

[Dimitris Milonas]

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