Update method in dataadapter

[yraykar]

Hi All,

 

I am using the dataadapter to update the source but i am getting an error. The modification involves change in boolean, datetime, int and string values. I am calling the method as follows

 

da.Update(custDS,"GROUP");

 

"Incorrect syntax near keyword 'Table_Name'"

 

Regards

Yashasvi

[Robby]

Does custDS contain the corect table name?

[yraykar]

Re: To Table name

 

Hi,

 

Yes the dataset has correct table name. The version used is VS.NET 2002 Framework version 1.0.3705.

 

The name was set like this:

 

custDS.Tables[0].TablesName="GROUP"

 

Just ignore the syntax mistakes here if any, i have done it this way with proper syntax.

 

Regards

Yashasvi

[Mehyar]

Are you using Stored procedures or SQL statements for your data adapters ?

[yraykar]

Stored procedures

 

Hi,

 

Not using stored procedures. Just using the tables directly

 

Regards

Yashasvi

[Mehyar]

Check your SQL statements, do they have a table that is not in the database ?

[yraykar]

Hi

 

Did not use SQL statements either. Updated the table as below

 

updateDS.Tables[0]["FieldName"]=currDS.Tables[0]["FieldName"]

 

Regards

Yashasvi

[jfackler]

If INSERT, UPDATE, or DELETE statements have not been specified, the Update method generates an exception.