From: Peted on
Hey
Using C# vs2008 .net 3.5

I have a winforms app where a user can create a "new " document, enter
data in several textboxes and then save the information.

As the user is entering information i was going to use a typed dataset
with several tables with relationships to store the information.
then when the user saves i want to save the dataset to sql database.

The dataset is one ive put together using the designer in vs2008.

Si i know you can use a sqlDataAdaptor to connect to an existing
database and populate/create a strongly typed dataset from it.
But this relys on the database exisiting first.

What can i do if the Dataset exists first with new data, then i want
to create the database file and save the dataset (inc all data and
tables and types etc etc)

Can anyone give us an idea of how best to acomplish this using the
ADO.net

thanks for any help


Peted