c# How to use linq to get xml string by filtering some data?

Question

I want to get xml string by filtering data. For example, I need to filter some students whose sex is female.

I need to use linq to xml to get xml string. The following is my initial xml code and expected xml string.

Initial xml code:

 <? xml version="1.0" encoding="utf-8"?>
    <School>
    <Student>
          <Name>Test1</Name>
          <Birthday>1997-02-23</Birthday>
          <Id>1001</Id>
          <Sex>male</Sex>
          <ClassId>01</ClassId>
          <Scorevalue>Net Revenue</Scorevalue>
    </Student>
    <Student>
          <Name>Test1</Name>
          <Birthday>1998-02-21</Birthday>
          <Id>1002</Id>
          <Sex>female</Sex>
          <ClassId>02</ClassId>
          <Scorevalue>Net Revenue</Scorevalue>
    </Student>
    <Student>
          <Name>Test1</Name>
          <Birthday>1997-02-24</Birthday>
          <Id>1004</Id>
          <Sex>male</Sex>
          <ClassId>03</ClassId>
          <Scorevalue></Scorevalue>
    </Student>
    </School>

Expected xml string:

<School>
  <Student>
    <Name>Test1</Name>
    <Birthday>1998-02-21</Birthday>
    <Id>1002</Id>
    <Sex>female</Sex>
    <ClassId>02</ClassId>
    <Scorevalue>Net Revenue</Scorevalue>
  </Student>
</School>

AnonymousKKYY · Accepted Answer · 2019-08-02 08:43:21Z

2

You can get the xml string like this,

string path = "D:\\test.xml";
XDocument doc = XDocument.Load(path);
doc.Descendants("Student").Where(x =>x.Element("Sex").Value=="male").Remove();
Console.WriteLine(doc.ToString());

answered Aug 2, 2019 at 8:43

AnonymousKKYY

3,7754 gold badges15 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jiachen Li-MSFT · Accepted Answer · 2022-03-11 07:40:29Z

0

Use the following code.

        XDocument doc = XDocument.Load(path);
        foreach(var x in doc.Descendants("Student").Where(x => x.Element("Sex").Value == "female"))
        {
            Console.WriteLine(x.ToString());
        }

answered Mar 11, 2022 at 7:40

Jiachen Li-MSFT

4817 gold badges13 silver badges24 bronze badges

Collectives™ on Stack Overflow

c# How to use linq to get xml string by filtering some data?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related