论坛交流
首页办公自动化| 网页制作| 平面设计| 动画制作| 数据库开发| 程序设计| 全部视频教程
应用视频: Windows | Word2007 | Excel2007 | PowerPoint2007 | Dreamweaver 8 | Fireworks 8 | Flash 8 | Photoshop cs | CorelDraw 12
编程视频: C语言视频教程 | HTML | Div+Css布局 | Javascript | Access数据库 | Asp | Sql Server数据库Asp.net  | Flash AS
当前位置 > 文字教程 > Asp.net教程
Tag:静态页面,treeview,gridview,repeater,dataset,sqldatareader,ado.net,上传,三层,ajax,xml,留言本,新闻发布,商城,注入,存储过程,分页,安全,优化,xmlhttp,fso,jmail,application,session,防盗链,stream,无组件,组件,md5,乱码,缓存,加密,验证码,算法,cookies,ubb,正则表达式,水印,索引,日志,压缩,base64,url重写,控件,Web.config,JDBC,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,IIS,触发器,socket,form认证,登录,视频教程

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

文章类别:Asp.net | 发表日期:2008-10-5 22:10:34

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

视频教程列表
文章教程搜索
 
Asp.net推荐教程
Asp.net热门教程
看全部视频教程
购买方式/价格
购买视频教程: 咨询客服
tel:15972130058