作者oishii (喔帅)
看板Web_Design
标题[问题] 关於资料库更新的问题
时间Sat Apr 5 15:46:29 2008
※ [本文转录自 C_Sharp 看板]
作者: oishii (喔帅) 看板: C_Sharp
标题: [问题] 关於资料库更新的问题
时间: Sat Apr 5 15:45:55 2008
当传递拥有新资料列的 DataRow 集合时，更新需要有效的 InsertCommand。
请问上面这句错误讯息是什麽意思呢？
我的程式码如下
......
行 40: objDataRow["NickName"] = "xxx";
行 41: objDataSet.Tables["Player"].Rows.Add(objDataRow);
行 42: int count=objDataAdapter.Update(objDataSet,"Player");
行 43: objCon.Close();
还请高手指点 谢谢！
--
下面是堆叠追踪
[InvalidOperationException: 当传递拥有新资料列的 DataRow 集合时，更新需要有效
的 InsertCommand。]
System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs
rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +252
System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs
rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) +46
System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping) +1765
System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable,
DataTableMapping tableMapping) +41
System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
+181
ASP.dbpractice_aspx.__Render__control1(HtmlTextWriter __w, Control
parameterContainer) in c:\Inetpub\wwwroot\Ch10\DBPractice.aspx:42
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer,
ICollection children) +98
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
System.Web.UI.Page.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer,
ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter
adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7423
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.64.83.154
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.64.83.154
※ 编辑: oishii 来自: 210.64.83.154 (04/05 15:49)
1F：推 pm2001:你objDataAdapter的update写了没? 04/05 15:52