hello to all,

Can u plz any body help me i have some xml files i have to import data into database. While importing i got a problem below are the details.

<ProviderInformation>
  <ProviderName>xxx</ProviderName>
    <ProviderSpecialty>yyy</ProviderSpecialty>
    <ProviderAddress>ssss</ProviderAddress>
    <Status>Active</Status>
  <ProviderName>xxx</ProviderName>
    <ProviderSpecialty>yyy</ProviderSpecialty>
    <ProviderAddress>ssss</ProviderAddress>
    <Status>Terminate</Status>
<HospitalInformation>
----
----
When i load the xml (_XmlDoc.LoadXml) i have to load only active providers information.
    or
When i give getElementsByTagName(ProviderName) i have to get only active providers.
Please anybody help me.