XML and SQL database

[Petr Jankovský]

Hello,
I have a XML file from the client and I need to insert data from XML to SQL
database. I know how to insert XML file to ASP.NET dataset, but don't know
how to insert data FROM dataset to database. I know how to insert one row to
database (Insert into etc.) but can't find out how to insert the whole
dataset. Any suggestions?

 

[Guest]

Take a look at the SqlDataAdapter and its Update method, which needs
respective SqlCommands and accepts a DataTable or a DataSet as input.
Peter

 

[sloan]

http://www.sqlservercentral.com/columnists/sholliday/thezerotonparameterproblem.asp

CHeck that article.

The XML I send in is just a DataSet (xml).

Once you have the data into @variable or #temp tables, you can do whatever
you want with it.

(aka, you don't have to build WHERE clauses with it, you can insert it into
the database).

You can find 3 tibbits I've written with this search also:

http://groups.google.com/groups/search?q="alreadyExists+bit"