DB Structure to Dataset

[Ale K.]

i will repost my question trying to explain it on a better way...

i got a DB on SQL Server 2000 and what i want to do is get the structure of
the DB and drop it on a dataset so i can work with this structure on my
program.... what i don't want to do is check the DB everytime i create an
instance of the DB to get the structure, there is a way to do this getting a
XSD file from the DB and loading the structure into a Dataset from this
file??

Thanks.
Alex.

 

[Yilei Wang]

You could generate an XSD file inside VS.NET once, and keep this file as
the dataset schema. When you need this schema in a project later, simply
add this xsd file back into the project, set Custom Tool property to
MSDataSetGenerator in the Properties window. This will generate a .vb file
for the schema file. You can now create a typed dataset using this schema.

Thanks and have a good day!

Yilei Wang [MS]

****************************************************************************
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
****************************************************************************