469,287 Members | 2,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,287 developers. It's quick & easy.

TableAdapter.Update() does not really change the database

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?

Jan 8 '07 #1
5 20460

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 ?

Jan 9 '07 #2
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 ?
Jan 9 '07 #3
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 ?

Jan 28 '07 #4
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 ?


Jan 28 '07 #5
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 ?


Jan 29 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by John Moore | last post: by
6 posts views Thread by craigkenisston | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.