Reading XML data

[NewTerminator]

I have a XML document that looks like the one below:

<rootelement>
<elementparent>
<child1>child1 </child1>
<child2>child2 </child2>
</elementparent>
<elementparent>
<child1>child1 </child1>
<child2>child2 </child2>
<child3>
<subchild>Testing</subchild>
</child3>
</elementparent>

</rootelement>

I would like to store these element information into the database. The example that has been displayed on top is a small part of a huge XML document that drills down to several inconsistent child nodes (like child3 above). Is there anyway i can read the data from the XML elements and store them in the database without using DOM?

I want to use Microsoft technologies to solve the problem.

Any help will be greatly appreciated

 

[chiph]

Take a look at the SAX parser (part of MSXML library).

What you do is point the .Parse method at your file, and it then raises events which you handle. The event you'll be most concerned with is EndElement, in which you look for the element corresponding to the end of your record. At that point you create your INSERT statement and send the data off to the database.

Chip H.

 

[palbano]

Microsoft Knowledge Base Article - 316018

HOW TO: Update SQL Server Data by Using XML Updategrams

http://support.microsoft.com/default.aspx?scid=kb;en-us;316018

-pete