作者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
※ 编辑: oishii 来自: 210.64.83.154 (04/05 15:49)