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?

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

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

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Petr Jankovský" wrote:

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?

[sloan]

http://www.sqlservercentral.com/colu...terproblem.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/sear...yExists+bit%22


"Petr Jankovský" <tu***@tuhyk.czwrote in message
news:OR**************@TK2MSFTNGP02.phx.gbl...

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?