How to Check a Particular Element has a Value or elements ?

How to check a particular Element has a value or inner elements?

here I have a list of Students, by using the name as search key displaying their results to richtextbox but here I have a problem where it comes to smith like students, I have one more table inside it as a list of marks, how to check and display

Do that particular element have value or elements?

I am using C# and LINQ to retrieve the data.

Raj

330

2019-09-12T10:22:45.607189+5

Shiv

580

2019-09:22:45.6071899+2:30

Dennis

514

2019-09-12T10:2:45.6071899

Lisa

510

2011-02-12T10:22:45.6071899+1:30

Laxmi

380

2019-09-12T10:22:45.6071899+05:30

Rahul

490

2019-09-12T10:22:45.6071899+05:30

Smith

2013-01-16T10:40:00.862238-08:00

Jessy

540

0001-01-01T00:00:00-08:00

XDocument doc = XDocument.Load(@"filename");

IEnumerable AllStudntElements = doc.Root.Elements();

var SelectDataByName = from element in AllStudntElements

where element.Element("Name").Value == SearchtItem

select element;

using for each loop it is working perfectly for every student but like smith how to check whether total marks have inner elements or not and how to display Marks and Results as a list for smith like students?

I have tried everything like **has children,hasAttribute** but nothing giving proper results?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prem Anandh J7y ago
1. string xml = "xml file path"//Get your XML here
2. XElement doc= XElement.Parse(xml);
1. Use LINQ to get any value to XML .
2. Load the XML into element
4. var items = doc.Descendants("field")
                 .Where(node => (string)node.Attribute("name") == "Name")
                 .Select(node => node.Value.ToString())
                 .ToList();
  Example
5. var items = doc.Descendants("Name")
                 .Where(node => (string)node.Attribute("name") == "Laxmi")
                 .Select(node => node.Value.ToString())
                 .ToList();