How do I refresh a dataset?

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?

RE: How do I refresh a dataset?

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

"Larry Bud" wrote:

> 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?
>