软件下载 | 资讯教程 | 最近更新 | 下载排行 | 一键转帖 | 发布投稿
您的位置:最火下载站 > 网络编程 > SQL SERVER > 将截断字符串或二进制数据 语句已终止

将截断字符串或二进制数据 语句已终止

  将截断字符串或二进制数据。语句已终止…… 

  我在设计数据库的时候准备在一个表中设计一个NContent字段,它的数据类型为varchar(50),由于是在可视模式下新建的,没有太注意,也许是鼠标滑轮不小心滑动力,导致NContent字段的数据变成了:nvarchar()类型了,所以在后来的添加数据时就出现了“将截断字符串或二进制数据。语句已终止……”的错误提示。。。

  解决办法当然有多种,一是修改数据库字段大小; 二是加强数据强壮性,严格的输入判断。 目前是采用修改数据的方法:alter table1 alter column caller varchar(50)

以下为引用的内容:
Server Error in '/Rainbow' Application.
--------------------------------------------------------------------------------

将截断字符串或二进制数据。语句已终止。
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: 将截断字符串或二进制数据。语句已终止。

Source Error:


Line 488: myInputs.Add("InputParams" , InputParams);
Line 489: myInputs.Add("RealModuleID" , ModuleID);
Line 490: workflow.DoAction(wid, actionId, myInputs);
Line 491: #region
Line 492: #region

Source File: C:\Inetpub\wwwroot\Rainbow\DesktopModules\TaokeCatalogs\Actions\Do.ascx.cs Line: 490

Stack Trace:

[SqlException: 将截断字符串或二进制数据。
语句已终止。]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
NHibernate.Impl.NonBatchingBatcher.AddToBatch(Int32 expectedRowCount) +43
NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Boolean[] includeProperty, Object oldVersion, Object obj, SqlString sqlUpdateString, ISessionImplementor session) +709
NHibernate.Persister.EntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Object[] oldFields, Object oldVersion, Object obj, ISessionImplementor session) +111
NHibernate.Impl.ScheduledUpdate.Execute() +134
NHibernate.Impl.SessionImpl.ExecuteAll(IList list) +128
NHibernate.Impl.SessionImpl.Execute() +103

[ADOException: could not synchronize database state with session]
NHibernate.Impl.SessionImpl.Execute() +184
NHibernate.Impl.SessionImpl.Flush() +27
NHibernate.Transaction.AdoTransaction.Commit() +101
DotNetTools.Workflow.Spi.Hibernate.HibernateWorkflowStore.MarkFinished(IStep step, Int32 actionId, DateTime finishDate, String status, String caller) in D:\Working\Workflow\Workflow-Old\src\DotNetTools.Workflow\Spi\Hibernate\HibernateWorkflowStore.cs:309

[StoreException: Saving current step with action 102]
DotNetTools.Workflow.AbstractWorkflow.DoAction(Int64 id, Int32 actionId, IDictionary inputs) in D:\Working\Workflow\Workflow-Old\src\DotNetTools.Workflow\AbstractWorkflow.cs:721
Rainbow.DesktopModules.TaokeCatalogs.Actions.Do.DirectDoWorkflowAction(String sWid, Int32 actionId, User user) in C:\Inetpub\wwwroot\Rainbow\DesktopModules\TaokeCatalogs\Actions\Do.ascx.cs:490
Rainbow.DesktopModules.TaokeCatalogs.Actions.Do.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Rainbow\DesktopModules\TaokeCatalogs\Actions\Do.ascx.cs:79
System.Web.UI.Control.OnLoad(EventArgs e) +67
Rainbow.UI.WebControls.PortalModuleControl.OnLoad(EventArgs e) in C:\Inetpub\wwwroot\Rainbow\app_code\Rainbow\UI\WebControls\PortalModuleControl.cs:710
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.AddedControl(Control control, Int32 index) +307
System.Web.UI.ControlCollection.Add(Control child) +153
System.Web.UI.WebControls.RowControlCollection.Add(Control child) +33
DUEMETRI.UI.WebControls.DesktopPanes.CreateControlHierarchy() +1129
DUEMETRI.UI.WebControls.DesktopPanes.CreateChildControls() +27
Rainbow.UI.WebControls.DesktopPanes.CreateChildControls() in C:\Inetpub\wwwroot\Rainbow\app_code\Rainbow\UI\WebControls\DesktopPanes.cs:138
System.Web.UI.Control.EnsureChildControls() +100
System.Web.UI.Control.PreRenderRecursiveInternal() +38
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Control.PreRenderRecursiveInternal() +125
System.Web.UI.Page.ProcessRequestMain() +1489

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

    相关阅读
    网友评论
    栏目导航
    推荐软件