Updating Dataset

[ArielR]

If I have 2 datasets in which an updating to a table at dataset1 perform changes to the other table at dataset2... How to update this changes at Dataset2?. Must use tableadapter.fill( dataset2.mytable); does exist other way than refill?. thanks...

[Dave Kreskowiak]

I can't really understand your explanation, but I think you said you wanted to make changes to, or update the contents of, DataSet2 based on a change in DataSet1?? There is no automatic facility to do this. You have to write the code to get the data for DataSet2 or make the appropriate changes to it. Like I said, your explanation is not very clear or understandable.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008

[Christian Graus]

No, ADO.NET is disconnected, you need to refill the grid. Unless you can manually copy the specific change from dataset1, but that's more work, it just saves you DB resources.

Christian Graus Driven to the arms of OSX by Vista.

[ArielR]

Yes Dave. This is the question. and sorry if it was ununderstandable. Thank you very much....

[ArielR]

Ok, thanks. I looking the way to have a low cost at the network traffic, and refill method isn't help me. I need the users have the real product amount if others make an invoice....