广

ASP.NET

  • IOS开发
  • android开发
  • PHP编程
  • JavaScript
  • ASP.NET
  • ASP编程
  • JSP编程
  • Java编程
  • 易语言
  • Ruby编程
  • Perl编程
  • AJAX
  • 正则表达式
  • C语言
  • 编程开发

    解决错误:sql_variant is incompatible with xml (ASP.NET 2.0

    2018-04-05 08:32:10 次阅读 稿源:互联网
    广告

      发生场景:
      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"

      http://cleo.cnblogs.com/archive/2006/05/22/406577.html

    一起学吧部分文章转载自互联网,供读者交流和学习,若有涉及作者版权等问题请及时与我们联系,以便更正、删除或按规定办理。感谢所有提供资讯的网站,欢迎各类媒体与一起学吧进行文章共享合作。

    广告
    广告
    广告