作者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