[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

RE: OleDBAdapter - Syntax error on Update Statement

Shaning

3/10/2009 8:12:00 PM

In a C# program,

dataAdapter.UpdateCommand.CommandText = "UPDATE myTable set Size = 1000000, Table1_Records = 1804 where DB_Name = 'my.mdb' "
dataAdapter.UpdateCommand.ExecuteNonQuery();

I received a Syntax error in the Update Statement.

However, I used the same Update statement in the Access file, it run well.

Does anyone know how to fix it? Thanks.
UpdateCommand.ExecuteNonQuery

From http://www.development...22_2003_10_0_0_107249/OleDBAdapter--error-on-ExecuteNo...

Posted via DevelopmentNow.com Groups
http://www.development...