作者EvilSmile (空间上的转换)
看板C_Sharp
标题Re: [问题] 请问c#与access沟通的题!
时间Fri May 5 15:29:25 2006
※ 引述《horngsh (foreman)》之铭言：
: 试试用如下的方法:
: DataRow aRow = thisDataSet.Tables["_dbTable"].Rows[1];
: aRow["Number"] = "1800";
: then :
: thisAdapter.Update(thisDataSet, "_dbTable");
: 希望有帮助!
Unhandled Exception: System.Data.OleDb.OleDbException: UPDATE 陈述式的语法错误
。
at
System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArg
s rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs
rowU
pdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMappi
ng tableMapping)
at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable
dataTable,
DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at ConsoleApplication1.Program.updateDB() in C:\Documents and
Settings\Admini
strator\My Documents\Visual Studio
2005\Projects\ConsoleApplication1\ConsoleAppl
ication1\Program.cs:line 143
at ConsoleApplication1.Program.Main(String[] args) in C:\Documents and
Settin
gs\Administrator\My Documents\Visual Studio
2005\Projects\ConsoleApplication1\Co
nsoleApplication1\Program.cs:line 17
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 211.74.94.189
1F：→ EvilSmile:仍然是失败ㄝ@@ 05/05 15:29