Hi all,

Can someone show me an example about how to use updatecommand to update a dataset in the ado.net. I am using oledbadapter and what i did is as follow

...
myoleadapter.update(mydateset, mytablename)
....

the strange thing is sometime it's okay, i.e., the table gets updated in the database, but sometime a error msg is thrown out as "syntax error in the update command" , even for the same table. I checked the table to see if there is any relation or none-zero constraint, but no constraint at all. Any idea ? thanks.