create a table using xml schema

[mathumathi]

hai
i have an xml doc and its schema, i want to create a table with the schema of the xml file. can any one tell me how to do it or the vb.net code to do it.
thanks

 

[JohnH]

Use "Add existing" to add the xsd schema to project, this represent a strongly typed dataset with one or more tables. You can review/edit the set in Designer. It will also be available in the Data Sources window where you can drag a table to a form to have UI controls and binding objects generated. In code you can use or create the generated classes, f.ex:

Dim dt As New schemaDataset.strongDataTable

It is also possible to create "weak" datasets/datatables by creating a Dataset instance and read the schema dynamically with ReadXmlSchema method. But you should spend some time exploring the possibilities I described first.