XML - DataSet - SQL Database

Question

Hi there i´m currently working on a tool that reads XML into a Dataset and writes it to a Database. The Dataset is filled with the XML-Data through ReadXML but i can´t insert the DataSet as is into the SQL Server. Is there a way to insert filled DataSet´s into SQL-Server without pre-existing tables? any suggestions how i can insert different XML-Files into SQL via c#? thanks a lotbest regards jkersch

miker · Answer

If you want to insert yor xml data into the database table you soppose to have this table. On the table creation look Data Definition Language (DDL) in Visual Studio Help.

jkersch · Answer

well there aren´t any tables in the database yet. i have an xml that looks like : Kaffeemaschine läßt sich nicht einschalten and i already loaded it into a ADO DataSet now i want it to be inserted into the database...any suggestions? do i have to create the tables before? doesn´t matter if c# or vb.net though i´d prefer a c# solution. thanks

miker · Answer

Could you be a little more specific? What do you mean by without pre-existing tables?

XML -> DataSet -> SQL Database