TableAdapter.Update() does not really change the database

[dani kotlar]

I run the following code:
this.carsBindingSource.EndEdit();
this.carsTableAdapter.Update( this.vehiclesDataSet.Cars );
in order to save changes in the dataset to the database, but the
changes don't take place in the database. Am I missing something?

 

[Karthik D V]

I run the following code:
this.carsBindingSource.EndEdit();
this.carsTableAdapter.Update( this.vehiclesDataSet.Cars );
in order to save changes in the dataset to the database, but the
changes don't take place in the database. Am I missing something?

Are you attched the Updated command to adapter ?

 

[dani kotlar]

Yes, I attached using Fill, changed the dataset, and now I want to
update the underlying database using update, but this does not work.

Dani


Karthik D V ëúá:

 

[Guest]

dani,
please let me know if you get an asnwer to this. I have the exact same issue
and cannot resolve it for days now. I am consigering going back to VB 6.0 for
this app I need at this point. Frustrating!

 

[Brooke]

You need to create the select, insert, delete, and update commands for the
DataAdapter, or use the commandbuiler class.

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.aspx

works fine for me...

 

[RobinS]

If you are using SQL Express, make sure you are updating the right copy of
the database. Check out this link:

http://msdn2.microsoft.com/en-us/library/ms246989(VS.80).aspx

Robin S.
----------------------------------------------