how to read data from multiple same node xml in c#

Question

0.00/5 (No votes)

See more:

 I want  to read the data from xml string so how to read it while it contains multiple same name node in head node any suggestion how can i do it may be some time it will be more and some time it will be one or none so which is best approach to adopt here is my sample xml

XML

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<GetPatientFullMedicationHistoryResponse xmlns="https://secure.newcropaccounts.com/V7/webservices">
<GetPatientFullMedicationHistoryResult>
<result>
<Status>OK</Status>
<Message />
<XmlResponse />
<RowCount>2</RowCount>
<Timing>0</Timing>
</result>
<patientDrugDetail>

<PatientDrugDetail>
<ExternalPatientID>166</ExternalPatientID>
<DrugID>183716</DrugID>
<DrugTypeID>F</DrugTypeID>
<DrugName>Pondimin</DrugName>
<Strength>20</Strength>
<StrengthUOM>mg</StrengthUOM>
</patientDrugDetail>

<PatientDrugDetail>
<ExternalPatientID>166</ExternalPatientID>
<DrugID>183716</DrugID>
<DrugTypeID>F</DrugTypeID>
<DrugName>Pondimin</DrugName>
<Strength>20</Strength>
<StrengthUOM>mg</StrengthUOM>
</PatientDrugDetail>

</patientDrugDetail>

</GetPatientFullMedicationHistoryResult>
</GetPatientFullMedicationHistoryResponse>
</soap:Body>
</soap:Envelope>

Posted 31-Mar-14 5:36am

Jawad Ahmed Tanoli

Updated 1-Apr-14 4:05am

v2

Add a Solution

Comments

[no name] 31-Mar-14 11:58am

Should that be <PatientDrugDetails> for the first patientDrugDetail element?

Jawad Ahmed Tanoli 31-Mar-14 12:09pm

yes it will be like this <patientDrugDetail> <PatientDrugDetail>some data tags</patientDrugDetail><PatientDrugDetail>some data tags</patientDrugDetail> </patientDrugDetail>

Jawad Ahmed Tanoli 31-Mar-14 12:10pm

there is a another node rowcount which will tell how many tags of <PatientDrugDetail>

2 solutions

Solution 1

Using Linq you could use

XML

IEnumerable<XElement> patDrugDet=
    from el in root.Elements("PatientDrugDetail")
    select el;

Posted 31-Mar-14 6:30am

Guruprasad.K.Basavaraju

Comments

Jawad Ahmed Tanoli 31-Mar-14 12:45pm

what is root ?
this xml is in string variable.do i need to convert it into some other data type like xml?

Guruprasad.K.Basavaraju 31-Mar-14 13:20pm

string str = @"YOUR_XML_STRING";
XElement root= XElement.Parse(str);

Jawad Ahmed Tanoli 1-Apr-14 10:09am

it return nothing

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Guruprasad.K.Basavaraju · Accepted Answer · 2014-04-01T07:14:00

Jawad,

I am not sure why you are getting nothing back. But try the below which is returning me 2 Patient drug detail records.

XML

string str = @"<?xml version=""1.0"" encoding=""utf-8""?> <soap:Envelope xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"" xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema""> <soap:Body> <GetPatientFullMedicationHistoryResponse xmlns=""https://secure.newcropaccounts.com/V7/webservices""> <GetPatientFullMedicationHistoryResult> <result> <Status>OK</Status> <Message /> <XmlResponse /> <RowCount>2</RowCount> <Timing>0</Timing> </result> <PatientDrugDetails>  <PatientDrugDetail> <ExternalPatientID>166</ExternalPatientID> <DrugID>183716</DrugID> <DrugTypeID>F</DrugTypeID> <DrugName>Pondimin</DrugName> <Strength>20</Strength> <StrengthUOM>mg</StrengthUOM> </PatientDrugDetail>  <PatientDrugDetail> <ExternalPatientID>166</ExternalPatientID> <DrugID>183716</DrugID> <DrugTypeID>F</DrugTypeID> <DrugName>Pondimin</DrugName> <Strength>20</Strength> <StrengthUOM>mg</StrengthUOM> </PatientDrugDetail>  </PatientDrugDetails>  </GetPatientFullMedicationHistoryResult> </GetPatientFullMedicationHistoryResponse> </soap:Body> </soap:Envelope>";

C#

XNamespace ns = "https://secure.newcropaccounts.com/V7/webservices";
XDocument doc = XDocument.Parse(str);
IEnumerable<XElement> list1 = doc.Descendants(ns+"PatientDrugDetail");

OR you could use LinQ as in Solution 1

C#

XNamespace ns = "https://secure.newcropaccounts.com/V7/webservices";
XNamespace soap = "http://schemas.xmlsoap.org/soap/envelope/";

XDocument doc = XDocument.Parse(str);
XElement root = doc.Root.Element(soap+"Body").Element(ns+"GetPatientFullMedicationHistoryResponse").Element(ns+"GetPatientFullMedicationHistoryResult").Element(ns+"PatientDrugDetails");
            
IEnumerable<XElement> patDrugDet = from el in root.Elements(ns + "PatientDrugDetail") select el;