I'd like to browse through the attached XML file using a grid. Eventually, I will need to import data from a file like this into a database. I'm very new to hierarchical grids, so a strong clue in the right direction would be appreciated.
In case the attachment did not work, here's the contents:
<creditBureau xmlns="http://www.transunion.com/namespace" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.transunion.com/namespace">
<document>response</document>
<version>2.8</version>
<transactionControl>
<userRefNumber>20999</userRefNumber>
<subscriber>
<industryCode>Z</industryCode>
<memberCode>05633723</memberCode>
<inquirySubscriberPrefixCode>0622</inquirySubscriberPrefixCode>
</subscriber>
<options>
<country>us</country>
<language>en</language>
</options>
<tracking>
<transactionTimeStamp>2012-03-30T13:43:56.627-05:00</transactionTimeStamp>
</tracking>
</transactionControl>
<product>
<code>07000</code>
<subject>
<number>1</number>
<subjectRecord>
<fileNumber>01</fileNumber>
<consumerID>10506984FB5B</consumerID>
<fileSummary>
<fileHitIndicator>regularHit</fileHitIndicator>
<ssnMatchIndicator>exact</ssnMatchIndicator>
<consumerStatementIndicator>false</consumerStatementIndicator>
<market>32</market>
<submarket>QU</submarket>
<creditDataStatus>
<suppressed>false</suppressed>
<doNotPromote>
<indicator>false</indicator>
</doNotPromote>
<freeze>
<indicator>false</indicator>
</freeze>
<minor>false</minor>
<disputed>false</disputed>
</creditDataStatus>
<inFileSinceDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">1983-04-23</inFileSinceDate>
</fileSummary>
<indicative>
<name source="file">
<person>
<first>ZELNINO</first>
<middle>XX</middle>
<last>WINTER</last>
</person>
</name>
<name source="file">
<qualifier>alsoKnownAs</qualifier>
<person>
<unparsed>SUMMER</unparsed>
</person>
</name>
<address source="file">
<status>current</status>
<qualifier>personal</qualifier>
<street>
<number>760</number>
<name>SPROUL</name>
<preDirectional>W</preDirectional>
<type>RD</type>
</street>
<location>
<city>FANTASY ISLAND</city>
<state>IL</state>
<zipCode>60750</zipCode>
</location>
<dateReported estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2008-07-16</dateReported>
</address>
<address source="file">
<status>previous</status>
<qualifier>personal</qualifier>
<street>
<number>555</number>
<name>ADAMS</name>
<preDirectional>W</preDirectional>
<type>ST</type>
</street>
<location>
<city>CHICAGO</city>
<state>IL</state>
<zipCode>60661</zipCode>
</location>
<dateReported estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2003-06-24</dateReported>
</address>
<socialSecurity source="file">
<number>666125812</number>
</socialSecurity>
<dateOfBirth estimatedYear="false" estimatedMonth="false" estimatedCentury="false" source="file" estimatedDay="false">1966-08-01</dateOfBirth>
<employment source="file">
<employer>
<unparsed>AJILON</unparsed>
</employer>
<occupation>IT</occupation>
<dateHired estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2006-05-01</dateHired>
<dateOnFileSince estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateOnFileSince>
</employment>
<employment source="file">
<employer>
<unparsed>AJILON</unparsed>
</employer>
<occupation>IT</occupation>
<dateHired estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2006-05-01</dateHired>
<dateOnFileSince estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateOnFileSince>
</employment>
</indicative>
<consumerFileData>
<statement>
<text>NEVER SAY MOE THAN IS NECESSARY</text>
</statement>
</consumerFileData>
<custom>
<credit>
<trade>
<subscriber>
<industryCode>R</industryCode>
<memberCode>060LA001</memberCode>
<name>
<unparsed>MT W VLY MHP</unparsed>
</name>
</subscriber>
<portfolioType>open</portfolioType>
<accountNumber>88</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2006-10-31</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000001849</currentBalance>
<highCredit>000001849</highCredit>
<creditLimit>000002500</creditLimit>
<accountRating>09</accountRating>
<remark>
<code>PRL</code>
<type>affiliate</type>
</remark>
<pastDue>000001849</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
</paymentHistory>
<updateMethod>locked</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BZ</industryCode>
<memberCode>06613014</memberCode>
<name>
<unparsed>PNC BANK</unparsed>
</name>
</subscriber>
<portfolioType>installment</portfolioType>
<accountNumber>65005002</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-09-24</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000008677</currentBalance>
<highCredit>000009005</highCredit>
<accountRating>02</accountRating>
<terms>
<paymentFrequency>monthly</paymentFrequency>
<paymentScheduleMonthCount>60</paymentScheduleMonthCount>
<scheduledMonthlyPayment>000000333</scheduledMonthlyPayment>
</terms>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>21X11X111X11111X11111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>21</monthsReviewedCount>
<late30DaysTotal>01</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BM</industryCode>
<memberCode>0860V001</memberCode>
<name>
<unparsed>EQUICREDIT</unparsed>
</name>
</subscriber>
<portfolioType>mortgage</portfolioType>
<accountNumber>009985</accountNumber>
<ECOADesignator>jointContractLiability</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2005-11-08</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000100</currentBalance>
<highCredit>000000104</highCredit>
<accountRating>01</accountRating>
<terms>
<paymentFrequency>monthly</paymentFrequency>
<paymentScheduleMonthCount>168</paymentScheduleMonthCount>
<scheduledMonthlyPayment>000000967</scheduledMonthlyPayment>
</terms>
<account>
<type>CV</type>
</account>
<pastDue>000000000</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>1111XXX111111111111X1111111111X1111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>48</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BI</industryCode>
<memberCode>0728P546</memberCode>
<name>
<unparsed>MELLON BK-E</unparsed>
</name>
</subscriber>
<portfolioType>revolving</portfolioType>
<accountNumber>69</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2003-08-04</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000657</currentBalance>
<highCredit>000001200</highCredit>
<creditLimit>000001500</creditLimit>
<accountRating>01</accountRating>
<pastDue>000000000</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>111111111111111111111111111111111111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>48</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>BC</industryCode>
<memberCode>01597029</memberCode>
<name>
<unparsed>BK OF AMER</unparsed>
</name>
</subscriber>
<portfolioType>revolving</portfolioType>
<accountNumber>5674449044</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-04-22</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000000</currentBalance>
<highCredit>000001005</highCredit>
<creditLimit>000002500</creditLimit>
<accountRating>01</accountRating>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-02-01</startDate>
<text>11111111111111111111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>25</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<trade>
<subscriber>
<industryCode>VZ</industryCode>
<memberCode>01066024</memberCode>
<name>
<unparsed>CRESTAR BANK</unparsed>
</name>
</subscriber>
<portfolioType>installment</portfolioType>
<accountNumber>976771</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2003-10-31</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2011-01-13</dateEffective>
<dateClosed estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2011-01-18</dateClosed>
<closedIndicator>normal</closedIndicator>
<currentBalance>000000000</currentBalance>
<highCredit>000002623</highCredit>
<accountRating>01</accountRating>
<remark>
<code>CLO</code>
<type>affiliate</type>
</remark>
<terms>
<paymentFrequency>monthly</paymentFrequency>
<paymentScheduleMonthCount>64</paymentScheduleMonthCount>
<scheduledMonthlyPayment>000000051</scheduledMonthlyPayment>
</terms>
<account>
<type>ST</type>
</account>
<pastDue>000000000</pastDue>
<paymentHistory>
<maxDelinquency>
<earliest>false</earliest>
</maxDelinquency>
<paymentPattern>
<startDate estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-12-13</startDate>
<text>XXXXXXXXXXXXXX111111111111111111</text>
</paymentPattern>
<historicalCounters>
<monthsReviewedCount>48</monthsReviewedCount>
<late30DaysTotal>00</late30DaysTotal>
<late60DaysTotal>00</late60DaysTotal>
<late90DaysTotal>00</late90DaysTotal>
</historicalCounters>
</paymentHistory>
<updateMethod>manual</updateMethod>
</trade>
<collection>
<subscriber>
<industryCode>Y</industryCode>
<memberCode>098MC001</memberCode>
<name>
<unparsed>RECOVERY SYS</unparsed>
</name>
</subscriber>
<portfolioType>open</portfolioType>
<accountNumber>19899</accountNumber>
<ECOADesignator>individual</ECOADesignator>
<dateOpened estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-05-07</dateOpened>
<dateEffective estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-01</dateEffective>
<currentBalance>000000293</currentBalance>
<original>
<creditGrantor>
<unparsed>MEDICAL</unparsed>
</creditGrantor>
<creditorClassification>medicalOrHealthCare</creditorClassification>
<balance>000000293</balance>
</original>
<pastDue>000000293</pastDue>
<accountRating>9B</accountRating>
<remark>
<code>CLA</code>
<type>affiliate</type>
</remark>
<updateMethod>locked</updateMethod>
</collection>
<publicRecord>
<type>PC</type>
<subscriber>
<industryCode>ZP</industryCode>
<memberCode>05048107</memberCode>
</subscriber>
<docketNumber>97000002040</docketNumber>
<attorney>N LEVI</attorney>
<plaintiff>FORD MOTOR CREDIT</plaintiff>
<dateReported estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-10-31</dateReported>
<dateFiled estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-10-31</dateFiled>
<datePaid estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2011-06-03</datePaid>
<liabilities>000000876</liabilities>
<ECOADesignator>individual</ECOADesignator>
<source>
<type>circuit</type>
</source>
</publicRecord>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>Z</industryCode>
<memberCode>05633723</memberCode>
<inquirySubscriberPrefixCode>06TR</inquirySubscriberPrefixCode>
<name>
<unparsed>TU INTERNAL</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-30</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>B</industryCode>
<memberCode>02382255</memberCode>
<inquirySubscriberPrefixCode>40LO</inquirySubscriberPrefixCode>
<name>
<unparsed>HSBC</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2012-03-24</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2010-01-22</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-11-30</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-06-27</date>
</inquiry>
<inquiry>
<ECOADesignator>individual</ECOADesignator>
<subscriber>
<industryCode>X</industryCode>
<memberCode>00000102</memberCode>
<inquirySubscriberPrefixCode>06US</inquirySubscriberPrefixCode>
<name>
<unparsed>TEST SUBCODE</unparsed>
</name>
</subscriber>
<date estimatedYear="false" estimatedMonth="false" estimatedCentury="false" estimatedDay="false">2009-03-31</date>
</inquiry>
<creditSummary>
<revolvingAmount>
<percentAvailableCredit>084</percentAvailableCredit>
<highCredit>000002205</highCredit>
<creditLimit>000004000</creditLimit>
<currentBalance>000000657</currentBalance>
<pastDue>000000000</pastDue>
<monthlyPayment>000000000</monthlyPayment>
</revolvingAmount>
<installmentAmount>
<highCredit>000009005</highCredit>
<creditLimit>000000000</creditLimit>
<currentBalance>000008677</currentBalance>
<pastDue>000000000</pastDue>
<monthlyPayment>000000333</monthlyPayment>
</installmentAmount>
<mortgageAmount>
<highCredit>000000104</highCredit>
<creditLimit>000000000</creditLimit>
<currentBalance>000000100</currentBalance>
<pastDue>000000000</pastDue>
<monthlyPayment>000000967</monthlyPayment>
</mortgageAmount>
<openAmount>
<percentAvailableCredit>026</percentAvailableCredit>
<highCredit>000001849</highCredit>
<creditLimit>000002500</creditLimit>
<currentBalance>000001849</currentBalance>
<pastDue>000001849</pastDue>
<monthlyPayment>000000000</monthlyPayment>
</openAmount>
<totalAmount>
<highCredit>000013163</highCredit>
<creditLimit>000006500</creditLimit>
<currentBalance>000011283</currentBalance>
<pastDue>000001849</pastDue>
<monthlyPayment>000001300</monthlyPayment>
</totalAmount>
<recordCounts reportingPeriod="totalHistory">
<publicRecordCount>001</publicRecordCount>
<collectionCount>001</collectionCount>
<totalTradeCount>006</totalTradeCount>
<negativeTradeCount>002</negativeTradeCount>
<historicalNegativeTradeCount>001</historicalNegativeTradeCount>
<historicalNegativeOccurrencesCount>001</historicalNegativeOccurrencesCount>
<revolvingTradeCount>002</revolvingTradeCount>
<installmentTradeCount>002</installmentTradeCount>
<mortgageTradeCount>001</mortgageTradeCount>
<openTradeCount>001</openTradeCount>
<unspecifiedTradeCount>000</unspecifiedTradeCount>
<totalInquiryCount>006</totalInquiryCount>
</recordCounts>
</creditSummary>
</credit>
</custom>
<addOnProduct>
<code>06500</code>
<status>delivered</status>
<highRiskFraudAlert>
<inquiryHistory timeframe="90Days">
<messageCode>5501</messageCode>
<inquiryWithCurrentInputCount>018</inquiryWithCurrentInputCount>
<maxInquiryCount>01</maxInquiryCount>
</inquiryHistory>
<identificationIssuance source="input">
<type>ssn</type>
<alertMessageCode>5504</alertMessageCode>
<yearRange>
<startYear>2008</startYear>
<endYear>0000</endYear>
</yearRange>
<state>CT</state>
<ageObtained>
<rangeStart>+40</rangeStart>
<rangeEnd>+41</rangeEnd>
</ageObtained>
</identificationIssuance>
<identificationIssuance source="file">
<type>ssn</type>
<alertMessageCode>5504</alertMessageCode>
<yearRange>
<startYear>2008</startYear>
<endYear>0000</endYear>
</yearRange>
<state>CT</state>
<ageObtained>
<rangeStart>+41</rangeStart>
<rangeEnd>+42</rangeEnd>
</ageObtained>
</identificationIssuance>
</highRiskFraudAlert>
</addOnProduct>
<addOnProduct>
<code>00P02</code>
<status>delivered</status>
<scoreModel>
<score>
<results>+581</results>
<derogatoryAlert>false</derogatoryAlert>
<fileInquiriesImpactedScore>false</fileInquiriesImpactedScore>
<factors>
<factor>
<rank>1</rank>
<code>038</code>
</factor>
<factor>
<rank>2</rank>
<code>013</code>
</factor>
<factor>
<rank>3</rank>
<code>018</code>
</factor>
<factor>
<rank>4</rank>
<code>020</code>
</factor>
</factors>
</score>
</scoreModel>
</addOnProduct>
<addOnProduct>
<code>07014</code>
<status>defaultDelivered</status>
<authUserAlert searchStatus="clear"/>
</addOnProduct>
<addOnProduct>
<code>07013</code>
<status>defaultDelivered</status>
<armAlert searchStatus="noHit"/>
</addOnProduct>
</subjectRecord>
</subject>
</product>
</creditBureau>
2 Answers, 1 is accepted
Thank you for writing.
Binding to XML is not directly supported by RadGridView. However, DataTables are supported and a DataSet (containing DataTables) can be created from an XML document. Once, you have the data filled in DataTables, you can set up the grid hierarchy. The following help article is quite useful on this topic:
https://docs.telerik.com/devtools/winforms/gridview/populating-with-data/bind-to-xml
https://docs.telerik.com/devtools/winforms/gridview/hierarchical-grid/binding-to-hierarchical-data-programmatically
I hope this information helps. Should you have further questions I would be glad to help.
Regards,
Dess
Progress Telerik
Rank 1