Is It difficult to create a table in SQL Server using A Dataset???

[hneal98]

Hi All,

I would like to create tables in SQL Server based on a dataset created from XML and XSD. Not sure how to go about it though. I am assuming I would have to use a For Each loop to go through the tables, columns etc. Haven't worked much with XML.

Any examples would be greatly appreciated.

Thanks in adavanced.

 

[PankajBanga]

See if these help you

http://www.c-sharpcorner.com/Code/2002/Mar/CreatingDBProgrammaticallyMCB.asp

http://www.vbdotnetheaven.com/Code/Jul2003/2130.asp

Email: pankajmsm@yahoo.com

 

[hneal98]

While this is great information, not sure how it relates to XML and XSD. Any thoughts about that?

 

[infinitelo]

This should be pretty straight forward.

<code>
Dim filename As String
Dim dsmylist As New DataSet("project")
filename = "filename.xml"
dsmylist.ReadXml(filename)
</code>
once read into a data set you should be able to use
insert into sql command.


if it is to be it's up to me

 

[hneal98]

How does that relate to creating a table on SQL Server from XML Dataset?

 

[DigitalGeek]

Once you have read the XML file to a DataSet, the field is wide open to manipulate it as you need. Which includes create new SQL tables.

 

[hneal98]

Thanks for your response.

How do I set up the relationships, field sizes, etc. from the tables in the datasets, in SQL?