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]

dani kotlar wrote:

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 ëúá:

dani kotlar wrote:

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 ?

[=?Utf-8?B?Q2hyaXM=?=]

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!
"dani kotlar" wrote:

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 כתב:

dani kotlar wrote:

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 ?

[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/lib...ndbuilder.aspx

works fine for me...

"Chris" <Ch***@discussions.microsoft.comwrote in message
news:AA**********************************@microsof t.com...

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!
"dani kotlar" wrote:

>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 ???:

dani kotlar wrote:
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 ?

[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/lib...89(VS.80).aspx

Robin S.
----------------------------------------------
"Chris" <Ch***@discussions.microsoft.comwrote in message
news:AA**********************************@microsof t.com...

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!
"dani kotlar" wrote:

>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 ???:

dani kotlar wrote:
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 ?