我想导入XML数据,使用C#的SQL Server 2000点网
任何一个职位的解决方案。
我有一个这样的XML文件,下面我所提到的。
- <shg_repayment_details>
- <data>
<tally_rec_id_code>452</tally_rec_id_code>
- <!-- To check already exit in our database
-->
<cluster_id>COICLT0001</cluster_id>
<unit_type>VIL</unit_type>
<vprc_id>COIVIL0001</vprc_id>
<shg_id>SHG1</shg_id>
<pip_no>10120aa</pip_no>
<name_of_the_member>BALA</name_of_the_member>
<type_of_loan>RF</type_of_loan>
<principal>500</principal>
<interest>600</interest>
</data>
- <data>
<tally_rec_id_code>453</tally_rec_id_code>
- <!-- To check already exit in our database
-->
<cluster_id>COICLT0001</cluster_id>
<unit_type>VIL</unit_type>
<vprc_id>COIVIL0001</vprc_id>
<shg_id>SHG2</shg_id>
<pip_no>10120BB</pip_no>
<name_of_the_member>BALAJI</name_of_the_member>
<type_of_loan>DL</type_of_loan>
<principal>300</principal>
<interest>500</interest>
</data>
</shg_repayment_details>