国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > .NET > 正文

解決錯誤:sql_variant is incompatible with xml (ASP.NET

2024-07-10 13:10:40
字體:
來源:轉載
供稿:網友

發生場景:
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"

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 靖边县| 平塘县| 东至县| 元阳县| 宜良县| 长泰县| 毕节市| 涡阳县| 二连浩特市| 东乌珠穆沁旗| 息烽县| 隆化县| 盘锦市| 永平县| 忻城县| 沂南县| 嘉禾县| 中牟县| 中江县| 漳州市| 柳林县| 福海县| 林口县| 法库县| 双牌县| 永兴县| 湘潭市| 资兴市| 五莲县| 皋兰县| 昌吉市| 新源县| 濮阳县| 万山特区| 柳州市| 九江市| 资兴市| 济南市| 泸州市| 兴义市| 德昌县|