Import XML and its attribute into SQL server 2000
Hi all,
I have this xml file
<root>
<TermAndCondition SectionTest="section1">
<TermTitle Section="section1" lvl="1">1. Test level 1.
<SubTitle Section="section1" TermTitle="1. " lvl="2">
a. Test Level a.
</SubTitle>
<SubTitle Section="section1" TermTitle="1. " lvl="2">
b. Test Level b.
</SubTitle>
</TermTitle>
</TermAndCondition>
</root>
What I would like to do is input this small xml data and its attribute into SQL server 2000 with C#. And I have a table in SQL server 2000 to store all these data. Can anyone have any sample codes please help? I am appreciated all helps.
|