How to refresh a typed dataset in Visual Studio 2005

[johnsmithme2004]

I have generated a typed dataset in Visual Studio 2005 by dragging
tables from Server Explorer onto the Designer surface. I then
configured adapters and added some methods based on stored procedures.

Now the underlying tables in the database were changed and I added and
remove some columns.

What is the best way to refresh the dataset so that it reflects the
changes?

Thank you,

jsmith

 

[Miha Markic [MVP C#]]

That's one disadvantage of dataset designer (IMO it is really useful just
for demos and small apps where the database structure doesn't change much).
Instead I would go with a template based code generator (i.e. CodeSmith) or
switch to an ORM product (i.e. LLBLGenPro).
Both ways you'll get much of the code autogenerated for free.