Count each header tag name in xml using c#

Question

Hi my code masters,

I trust all of you guys are doing just fine.

Please I have a challenge, I have a program that extract about 2,000 patient records in XML, and this XML have the following section:

HIVEncounter

Laboratory

Regimen

For each of these XML files I want to count each HIVEncounter, Laboratory and Regimen.

So that I can display them in the following format

File Name	HIVEncounters	Lab’s	Regimen

Thank you for your usual assistance

Answer 1

Hi

Use the below query:

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND
(Left$([Name],4) <> "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;

Thanks -- Vj

http://dotnetvj.blogspot.com