Hi,

Can we create a database directly from a dataset...?

Let's say in my C# program i have a dataset:

1)I have a dataset say
DataSet ds = new DataSet();

2) I add datatables,dataRelations to tables in the
dataset.

3) Add some datarows to the datatables

4)Now can I create a Database out of this dataset ????

[I don't want to create the database (from the asp.net
program) using sql scripts.The dataset needs to be
generated directly from dataset (or the .xsd)]
===========================================================
Alternatively:
When you create a typed dataset using the data controls in
VS.net a .xsd file gets created.
This .xsd file contains the entire schema for database
Now is there a way out to use this .xsd file to create a
database directly???

Pradeep,

Not directly. You'll have to use the DataSet's information to build SQL that
will update your database.

--
Kathleen (MVP-VB)



"Pradeep Masare" <(E-Mail Removed)> wrote in message
news:055e01c34f5d$2ea5da80$(E-Mail Removed)...
> Hi,
>
> Can we create a database directly from a dataset...?
>
> Let's say in my C# program i have a dataset:
>
> 1)I have a dataset say
> DataSet ds = new DataSet();
>
> 2) I add datatables,dataRelations to tables in the
> dataset.
>
> 3) Add some datarows to the datatables
>
> 4)Now can I create a Database out of this dataset ????
>
> [I don't want to create the database (from the asp.net
> program) using sql scripts.The dataset needs to be
> generated directly from dataset (or the .xsd)]
> ===========================================================
> Alternatively:
> When you create a typed dataset using the data controls in
> VS.net a .xsd file gets created.
> This .xsd file contains the entire schema for database
> Now is there a way out to use this .xsd file to create a
> database directly???