How to populate tree view from data table

[Sudip_inn]

see this is my xml from where i store data into data table

<?xml version="1.0" standalone="yes"?>
<EstimateConfigs>
<EstimateConfig>
<ActSection>Consensus Model</ActSection>
<ActLineItem>Net Revenue</ActLineItem>
<ActBroker>3A-P1</ActBroker>
<ActPeriod>2010 FYA</ActPeriod>
<Select>True</Select>
</EstimateConfig>
<EstimateConfig>
<ActSection>Consensus Model</ActSection>
<ActLineItem>Net Revenue</ActLineItem>
<ActBroker>3A-P1</ActBroker>
<ActPeriod>2011 FYA</ActPeriod>
<Select>True</Select>
</EstimateConfig>
<EstimateConfig>
<ActSection>Consensus Model</ActSection>
<ActLineItem>Net Revenue</ActLineItem>
<ActBroker>P1</ActBroker>
<ActPeriod>2010 FYA</ActPeriod>
<Select>True</Select>
</EstimateConfig>
<EstimateConfig>
<ActSection>Consensus Model</ActSection>
<ActLineItem>Net Revenue</ActLineItem>
<ActBroker>P1</ActBroker>
<ActPeriod>2011 FYA</ActPeriod>
<Select>True</Select>
</EstimateConfig>
</EstimateConfigs>

i want to create first node in tree view with all distinct ActBroker from datatable and each broker will have sub node like ActLineItem which will be also distinct as per ActBroker. i need to fetch ActLineItem as per ActBroker wise. how to do it

please guide me how to find out first unique ActBroker from data table and later each ActBroker node will have unique ActLineItem which is associated with broker. please help me. thanks

Continue reading...