Reading XML file in C#.net

leroylim

New Member
I am trying to read an XML response from 192.com.This is a validation of customer details.The XML response is set out as follows (Customer Details Removed):\[code\]<?xml version="1.0"?><Search Type="Result"> <CountryCode>GBR</CountryCode> <Person> <Name> <Forename>XXXXX</Forename> <Surname>XXXXX</Surname> </Name> <DateOfBirth>XXXX-XX-XX</DateOfBirth> <Age>XX</Age> </Person> <Addresses> <Address Current="1"> <Premise>X</Premise> <Postcode>XX99 9XX</Postcode> <CountryCode>GBR</CountryCode> </Address> </Addresses> <SearchOptions> <ProductCode>ProveID</ProductCode> </SearchOptions> <OurReference>XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX</OurReference> <SearchDate>2012-05-30T12:39:55</SearchDate> <Result> <Summary> <ReportSummary> <DatablocksSummary> <DatablockSummary> <Name>CreditReference</Name> <Decision>1</Decision> </DatablockSummary> </DatablocksSummary> </ReportSummary> </Summary> <CreditReference Type="Result"> <Summary> <Decision>1</Decision> <DecisionReasons> <DecisionReason> <Element>CreditReferenceSummary/TotalNumberOfVerifications</Element> <Decision>1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/OpenAccountsMatch</Element> <Decision>1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/DateOfBirthMatch</Element> <Decision>1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/ElectoralRollMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/ElectoralRollDateOfBirthMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/TelephoneDirectoryMatch</Element> <Decision>1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/BOEMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/PEPMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/OFACMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/DeceasedMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/COAMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/CIFASMatch</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/NoOfCCJ</Element> <Decision>-1</Decision> </DecisionReason> <DecisionReason> <Element>CreditReferenceSummary/NoOfOpenAccountsLenders</Element> <Decision>1</Decision> </DecisionReason> </DecisionReasons> </Summary> <CreditReferenceSummary> <CreditReferenceDecision/> <CreditReferenceScore/> <TotalNumberOfVerifications>7</TotalNumberOfVerifications> <OpenAccountsMatch>1</OpenAccountsMatch> <DateOfBirthMatch>1</DateOfBirthMatch> <ElectoralRollMatch>0</ElectoralRollMatch> <ElectoralRollDateOfBirthMatch>0</ElectoralRollDateOfBirthMatch> <TelephoneDirectoryMatch>1</TelephoneDirectoryMatch> <PhoneNumberMatch>0</PhoneNumberMatch> <DriverLicenceMatch/> <PassportMatch/> <DFATMatch/> <BOEMatch>0</BOEMatch> <PEPMatch>0</PEPMatch> <OFACMatch>0</OFACMatch> <DeceasedMatch>0</DeceasedMatch> <COAMatch>0</COAMatch> <CIFASMatch>0</CIFASMatch> <GoneAwayMatch/> <HighRiskAddressMatch/> <CommercialEntitiesAtAddressMatch/> <NoOfCommercialEntitiesAtAddress/> <NoOfCCJ>0</NoOfCCJ> <NoOfOpenAccountsLenders>5</NoOfOpenAccountsLenders> <IDVerified/> </CreditReferenceSummary> <CreditReferenceDetails> <StandardisedAddress Current="1"> <SubPremise/> <Premise>999999</Premise> <SubStreet/> <Street>XXXXXXXXX</Street> <SubLocality/> <Locality>XXXXXXXXXXXXXXXXXXX</Locality> <PostTown>XXXXXXXXXXXXXXXXXXX</PostTown> <Region>XXXXXXXXXXXXXXX</Region> <Postcode>XX999XX</Postcode> <CountryCode>GBR</CountryCode> </StandardisedAddress> </CreditReferenceDetails> </CreditReference> </Result></Search>\[/code\]I need to extract from this XML the elements for the following from the \[code\]<CreditReferenceSummary>\[/code\]
  • \[code\]<TotalNumberOfVerifications>7</TotalNumberOfVerifications>\[/code\]
  • \[code\]<OpenAccountsMatch>1</OpenAccountsMatch>\[/code\]
  • \[code\]<DateOfBirthMatch>1</DateOfBirthMatch>\[/code\]
  • \[code\]<DeceasedMatch>0</DeceasedMatch>\[/code\]
  • \[code\]<NoOfOpenAccountsLenders>5</NoOfOpenAccountsLenders>\[/code\]
Any help greatly appreciated. Thank you in advance.
 
Back
Top