473,239 Members | 1,545 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,239 software developers and data experts.

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 20784

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: delraydog | last post by:
If you've used the Google Gmail spell checker you know that it 'changes' the text area to another type of control that lets them show hyperlinks for the incorrect words. How does Google change the...
1
by: John Moore | last post by:
Hi, I normally work with Java but I'm interested in using Python as well, particularly for little tasks like doing some massaging of data in a MySQL database. Below is my first attempt. I'm sure...
1
by: eduardoben | last post by:
I use a tableadapter with the sql string = select * fom table where field=? I load the desired record in a form and populate textboxes but after i modify them when i use tableadapter.update it...
1
by: Magnus | last post by:
My situation compares to this: I have two tables parentTable(id, foreignId) and childTable(id, value). "foreignId" in the "parentTable" references "id" in "childTable". The constraint is by default...
6
by: craigkenisston | last post by:
How to change database name on the fly? I have an asp.net application in which a user connects to a sql server, where there's a centralized database with the users table and general settings....
2
GrandMaster
by: GrandMaster | last post by:
Can I create an update query to change all the dates in a column of data that is currently in this format: 0407 (so the first two digits are the month and the third and fourth digits are the year,...
15
by: Ms Rusty Boyd | last post by:
I am working in MS Access 2003 and I want to use the update query to change part of a value in a field. I have a last name field that contains a lot of records. Someone entered the values De Pedro...
0
jas16183
by: jas16183 | last post by:
Hi Guys, need some help here, Im working on a project in vb.net, the problem im facing is that my tableadapter.update(dataset.datatable) is not functioning, the datatable has a relation with...
8
by: Boris227 | last post by:
I have written an application that has a DataGridView for users to amend a table. When finished they click a 'Save' button, which generates a series of queries based on the new data. The problem...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.