How do I refresh a dataset?

[Larry Bud]

If I make a change in a SQL Table, the dataset in VS2005 needs to be
updated as well.

Is there any way to automatically refresh the dataset?

 

[JIGNESH]

if you are using wizard to generate dataset/Adaptor choose "Refresh Dataset"
option during WizardStep.

else

Put a ";" at the end of your SQL Insert/Update or Delete statement and
specify Select SQL statement.
eg. Insert into Table1 values (......) ; Select * from Table1

Regards
JIGNESH