解决错误:sql_variant is incompatible with xml (ASP.NET 2.0 / XML数据类型 )

王朝asp·作者佚名  2006-11-24
窄屏简体版  字體: |||超大  

发生场景:

1:如果数据表使用XML数据类型

2:使用ASP.net 2.0

3::使用向导生成SqlDataSource配合DetailsView新增/更新数据库XML数据类型

错误信息:

Server Error in '/' Application.

--------------------------------------------------------------------------------

Operand type clash: sql_variant is incompatible with xml

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Operand type clash: sql_variant is incompatible with xml

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

解决办法:

<DeleteParameters>

<asp:Parameter Name="original_ArticleID" Type="Int32" />

<asp:Parameter Name="original_Title" Type="String" />

<asp:Parameter Name="original_CategoryID" Type="Int32" />

<asp:Parameter Name="original_Contents" Type="String" />

<asp:Parameter Name="original_ArticleFrom" Type="String" />

<asp:Parameter Name="original_CreateDate" Type="DateTime" />

<asp:Parameter Name="original_keywordXML" Type="Object" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="Title" Type="String" />

<asp:Parameter Name="CategoryID" Type="Int32" />

<asp:Parameter Name="Contents" Type="String" />

<asp:Parameter Name="ArticleFrom" Type="String" />

<asp:Parameter Name="CreateDate" Type="DateTime" />

<asp:Parameter Name="keywordXML" Type="Object" />

<asp:Parameter Name="original_ArticleID" Type="Int32" />

<asp:Parameter Name="original_Title" Type="String" />

<asp:Parameter Name="original_CategoryID" Type="Int32" />

<asp:Parameter Name="original_Contents" Type="String" />

<asp:Parameter Name="original_ArticleFrom" Type="String" />

<asp:Parameter Name="original_CreateDate" Type="DateTime" />

<asp:Parameter Name="original_keywordXML" Type="Object" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="Title" Type="String" />

<asp:Parameter Name="CategoryID" Type="Int32" />

<asp:Parameter Name="Contents" Type="String" />

<asp:Parameter Name="ArticleFrom" Type="String" />

<asp:Parameter Name="CreateDate" Type="DateTime" />

<asp:Parameter Name="keywordXML" Type="Object" />

</InsertParameters>

将下划线部分Type="Object" -〉Type="String"

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航