Auto generate datasets from DB

[SPG]

Hi,

I am new to C#, and was wondering if there is an easy way to auto generate a
Dataset and the relevant classes (IE: Adapter for updating etc) by pointing
a wizard at the db?

I am sure there must be a way to do this..

Steve

 

[Uri Dor]

put a new dataadapter and use the query builder wizard to create the
query, then right-clicj on the adapter and select "generate dataset"

 

[SPG]

Thanks for that!
Saved me hours of work!

Mucho Grateful!

 

[Miha Markic [MVP C#]]

Hi,

As an another approach, check my website www.rthand.com, go to .NET
corner/Utilities.
There are two templates that creates save adapter (insert, update, delete
command) and a strong typed dataset with relations included.
Both templates are to be used with (free excelent utility) CodeSmith
template based code generator - you'll find more info on my website.