VB 2005 Express - How to backup a dataset
Hi people,
If I want at the beginning of my application to make a "safe copy"of a specific dataset, how can I do it?
I'll try to explain my doubts:
I have a datagridview with its datasource=Mydataset;
I have a combobox that gives information to the program to search the dataset;
Using the TableAdapters and with information from the combobox I'm using the crated query's and the fillby methods. When I fillby the dataset, any added or deleted rows from the dataset will only be true if I previously use the update method of the TableAdapter. The rejectchanges only work if the fiilby method was called one time at the beginning and the accept method was calledt(?), true?
If I want to accept this changes and still want to leave the aplication without any changes made to mydataset (for example: pressing the cancel button), how can I do it? I was thinking to use the backup copy made on the beginning of the application and use its contents to update the datatable again. Is this possible? Is there any other way?
I hope to be clear on this subject.
Please anyone answer me.
Thank you.
Pedro
