Rajkumar R

Rajkumar R

  • NA
  • 183
  • 220k

How to import XML data in c#

Nov 30 2011 2:37 AM
i want to import xml data using C# dot net to the SQLSERVER 2000
any one post solution for this
I have an XML file like this below i mentioned

<?xml version="1.0" encoding="utf-8" standalone="yes" ?> 
- <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>

Answers (6)