After creating a datasource and generating a dataset, my database has changed.
How can I "refresh" the dataset so it sees these changes.
One Method I have been able to do is delete the .xsd file from soultion explorer. There go my modified queries & code.
Another method tried was to re-drag/drop the table from Server Explorer to the DataSet design surface. However, it creates another instance of the table.
For example, if my table is named tbl_test, when I drop re-drop tbl_test on the surface, I now have another table talled tbl_test1
I don't want to delete the original tbl_test first, as I have modified the queries and code for it.
Am I missing something?
Is there a better way?