XML, Dataset & Sql Server

  • Thread starter Thread starter Ben
  • Start date Start date
B

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
 
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."
 
Back
Top