XML, Dataset & Sql Server

[Ben]

Hi, I'm reading XML into a dataset and now I want to insert into Sql Server
the data from the XML file. I haven't been able to figure out any other way
than to do this than to walk through the dataset and insert each record one
at a time.

If anyone can help, I'd appreciate it.

Ben

 

[Kevin Yu [MSFT]]

Hi Ben,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to know how to load data from
Xml file to SQL server. If there is any misunderstanding, please feel free
to let me know.

Loading the Xml file to a DataSet object and update them to the database is
a good choice. Besides, you can also use SQL Xml bulk load to achieve this.
You can build a .NET Framework-based application that shreds RSS feed data
into a database. Here are some useful articles and documents that you can
refer to. HTH.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/htm
l/exchsqlxml.asp
http://msdn.microsoft.com/xml/buildingxml/xmlanddatabase/
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm
/bulkload_3g30.asp

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Manuel Vázquez Acosta]

I think a DataAdapter may do the work for you.

Manuel.