Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Refreshing DataSet
- Thread starter sp76
- Start date
sp76,
There are two ways to do this
1. Use the dataadapter.Fill to refresh the entire database.
2. If you used the DataAdapter Wizard then make sure that the Refresh Data Set is selected on the Advanced SQL Generation Options. This will automatically place a Select command to run after an Insert or Update to get the most up-to-date info back into your dataset. This can also be done by writing your own Update and Insert commands and adding the Select statements after those.
Hope this helps,
Brian
There are two ways to do this
1. Use the dataadapter.Fill to refresh the entire database.
2. If you used the DataAdapter Wizard then make sure that the Refresh Data Set is selected on the Advanced SQL Generation Options. This will automatically place a Select command to run after an Insert or Update to get the most up-to-date info back into your dataset. This can also be done by writing your own Update and Insert commands and adding the Select statements after those.
Hope this helps,
Brian
- Status