Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing

Me.AddressesBindingSource.EndEdit()

Me.AddressesTableAdapter.Update(Me.SQLdbDataSet.Addresses)

End Sub

but all changes are lost when I restart the application.

Thanks.

I believe AddressesTableAdapter.Update invokes the AddressTableAdapter.UpdateCommand. Prior to calling Update you'll need to set AddressesTableAdapter.UpdateCommand = new SQLUpdateCommand...

Hope this helps,
Hal

I believe AddressesTableAdapter.Update invokes the AddressTableAdapter.UpdateCommand. Prior to calling Update you'll need to set AddressesTableAdapter.UpdateCommand = new SQLUpdateCommand...

Hope this helps,
Hal

I must have missed something in the documentation.  Everytime I would run this program The data would disappear.  Thanks for pointing out that there are two copies.

This definitely sounds like my problem. I hate to show my ignorance but can you tell me how I change these options?

Thanks,

can u plz explain what the command in UpdateCommand and how to make this cuz adressTableadapter.update has to return a value in int

thanks

I believe AddressesTableAdapter.Updateinvokes the AddressTableAdapter.UpdateCommand. Prior to calling Update you'll need to set AddressesTableAdapter.UpdateCommand = new SQLUpdateCommand...

Hope this helps,

Hal

Hi all !

Man, forget all !!!

If u using a bindindsource, verify your's components databindings. If they connected direct from dataset the updates not work. Bind using bindingsource object and done!

Sorry my english!!!

I hope helpful.

I'm having a similar issue wher the data is not updating. I don't have a local copy of the database at all. I'm connecting to a remotly hosting SQL Server 2005 database. Everything was working fine until yesterday and now it's as if the tables are all read-only. The TableAdapter.Update command never invokes the underlying Update method. The underlying update method that should be invoked is

public virtual int Update(DataTable dataTable) {

return this.Adapter.Update(dataTable);

"Found the solution in the free downloadable book 'Build a program now' at the 'Registration Benifit Program' p154 (text in blue)."

Where can I download this book? I to am having problems with the TableAdapter. My problem is when I try to update it tells me that .update is nota member of my workbook.

Thank you

Tom

I also have a problem updating the database:

I manually changed the datapath so I'm working directly on the database and for my customers table, it works fine but I've added another bindingadapter for the customercars table and when I add, it works fine but when I try to modify a record I get the following message:

Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

The update code is identical to the update code for the customers table and yet that updates fine. Any ideas guys?

Hi It seems like I can't grab this book (I've registered the prod.). Is there a link?

On the page there are just pics of books (in yellow or somethink). No downloads.

I'd appreciate if you were so kind to give me some more details.

Thanks in advance!

I am still confused. I understand about the database having two locations and that the property 'DO NOT COPY/ALWAYS COPY can be changed but my datanever gets back to the application database, whichever option is used.

I can see the data in the database residing in the bin\debug but I wany it to be permanently sent to the copy of the database in the application.

Do I need to add an SQL query to make this happen or what? Is there any code that copies the datatable from one location to the other.

Nobody else seems to be having the same problem .....are you?

Thanks for any help

Neil345

You don't have to have a copy of database in your project - just use the same one as always.

1. In Data sources tab click Add datasource

2. Select the type of DB and which files to import to the project. (test it just to see)

3. This will create a nice dataset which will be a copy of the originalDB files you select.

4. You can select names as you please.

5. When connecting to a database dont use "ok" use "no" when the message about including a copy of database pops-in.

6. You're done! Almost!!!

7. Also you willhave to mark your new dataset in Solution explorer as "Copy if newer" if you would want to update olddata with new one.

8. If you double click on a form with added table from Data sources (like Datagridview). You will get a code window for that form. Then choose the righ event for binding navigator(exactly when you want your dataset to be updated) like let's say:

Private Sub YourBindingSource_CurrentItemChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles YourBindingSource.CurrentItemChanged

Me.YourBindingSource.EndEdit()

Me.yourTableAdapter.Update(Me.YourDataSet.YourTable)

End Sub

Or any other event wth Binding source.

9. Reply to this post if it helps you so I will know if I was any good in helping.

Thanks Kdee

I appreciate your efforts in explaining but my problem is slightly different to the method that you are proposing.

I am creating a new dataset with an empty table but I am not using another database as my datasource. I am using XML to fill my datagrid from an external XML file. This works ok and I end up with a populated datagrid.

My problem is that I cannot update my database with this data. I can seethe table correctlyin the temporary database residing in bin/debug but I cannot get the data permanently stored in the other 'copy' of the database. When I exit my application the data is wiped.

I can change the data and then save it in a new xml file but I want to permanently save it in the applications database table.

Thanks for your help, please come back

Neil345

I believe my answer was correct after all.

It's a different case but... I believe ... the same problem. If you have created a copy of original DB which is generaly put in bin folder then ..you have to update the original DB MANUALY!!!!!! Copy the BIN DB to original DB.

Yes... at least as I understand it. I read some article about it, which ended my one and a half months headache.

The other solution is not to include original db to bin folder in this case you have to also set up all other things like I proposed in my last reply. Then the updated data from "project dataset" which is a "virtual mirror" of your original DB gets copied into the original DB and this automatically updates your original DB.

Many people have already asked about this problem with many headaches also ( almost everyone with more than several days of trying for themselves). See the past few months for articles in this forum and "VOILA" .... many people like you and me.

Maybe you will also find other solutions.

See ya!

Thanks for coming back again Kdee but you have completely lost me.

Can we just do a rewind and go through itagain

I am not using a database as a datasource,but I have a datasetwith anempty table. I get my data from an XML file which is designed to fit nicely intothis empty tables datagrid on my form. I then pull in the data ok and press the 'save' button but the update does not get propagnated to the underlying database.The correctdoes however then reside in a temporary file in the bin/debug. (WHY?)

You say that I have to manually copy it to my underlying database (still empty at this stage)

I don't understand why I should have to manually copy it and I don't know how to do that either.

There is something wrong with my basic understanding of what happens. Why isn't the table adaptor doing its job? Is it because it knows that it didn't supply the data via a data source? Why should it care?

I think its a fault in Visual Studio

Regards

Neil345

sorrry

Try to look further if anyone had the same problem as you. I believe I can not help you more. I hope you'll find the solution fast.

I tried all sorts of thing but in the end what worked was this

Go to the Data Sources Sidebar

Right click on the DataSet and click Edit DataSet with Designer

Right click on the Database and click Configure

Click Advanced Options and tick Generic Insert, Update and Delete Statements

I also ticked Use optimistic concurrency although I dont't think that was needed

Hopefully this helps someone else out of a headache

The Copy Always / Copy if Newer did the trick for me too. I was following the lessons in the Visual Studio Express Edititions learning center, but the lesson doesn't mention this option. I suppose that is because the lessons were created using a Beta version of Visual Studio Express.
I'm very happy I've found the solution here, cause it was driving me crazy

this thread is still working.

Have spent hours on this problem - and setting the property on the databse to "copy if newer" also worked for me.

GREAT.

thanks all.

You are my hero

I have spent a whole week trying to find out why this was happening with C#

I have tried several solutions in an effort to understand the architecture

I understand it now that you pointed out this annoyance

Thanks