Remove items from xml with specific date through linq to xml in C#

Question

I have xml file that looks like this..

<RecentInformation>
  <User Id="99">
    <Customers>
      <Customer>
        <CustomerId>7</CustomerId>
        <Date>1/20/2010</Date>
      </Customer>
      <Customer>
        <CustomerId>67</CustomerId>
        <Date>1/20/2010</Date>
      </Customer>
    </Customers>
    <Suppliers>
      <Supplier>
        <SupplierId>11619</SupplierId>
        <Date>1/20/2010</Date>
      </Supplier>
      <Supplier>
        <SupplierId>16274</SupplierId>
        <Date>1/20/2011</Date>
      </Supplier>
    </Suppliers>
    <Enquiries>
      <Enquiry>
        <EnquiryId>136202</EnquiryId>
        <Date>1/20/2010</Date>
      </Enquiry>
      <Enquiry>
        <EnquiryId>134507</EnquiryId>
        <Date>1/20/2011</Date>
      </Enquiry>
    </Enquiries>
    <Quotes>
      <Quote>
        <QuoteId>34008</QuoteId>
        <Date>1/20/2010</Date>
      </Quote>
      <Quote>
        <QuoteId>37356</QuoteId>
        <Date>1/20/2011</Date>
      </Quote>
    </Quotes>
    <Bookings>
      <Booking>
        <BookingId>3070</BookingId>
        <Date>1/20/2011</Date>
      </Booking>
      <Booking>
        <BookingId>3251</BookingId>
        <Date>1/20/2011</Date>
      </Booking>
    </Bookings>
  </User>
</RecentInformation>

I want to remove all the nodes that should be less then say 15 days old.

I am using this code but it is not working for me..

xdoc.Descendants("User").Descendants().Descendants().Where(x => DateTime.Parse(x.Element("Date").Value) < date)
                            .Remove();

any idea??

Describe "not working" ?

Henk Holterman
– Henk Holterman

2011-01-20 15:15:02 +00:00
Commented Jan 20, 2011 at 15:15 — Henk Holterman
– Henk Holterman, Commented Jan 20, 2011 at 15:15
exception thrown object reference not.....

Naveed Anjum
– Naveed Anjum

2011-01-20 15:18:07 +00:00
Commented Jan 20, 2011 at 15:18 — Naveed Anjum
– Naveed Anjum, Commented Jan 20, 2011 at 15:18

Dario · Accepted Answer · 2011-01-20 17:07:03Z

1

This is your line fixed

xdoc.Descendants("Date").Where(x => DateTime.Parse(x.Value) < date).Select(x=>x.Parent).Remove();

answered Jan 20, 2011 at 17:07

Dario

1492 bronze badges

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

2 Comments

Naveed Anjum Over a year ago

Sorry for late reply Dario. This code is working perfect for me. Thanx you so much you and all the guys who gives the answer.

Abhi Over a year ago

perhaps Naveed Anjum is new to SO hence he dont know he have to mark it as answered. :)

Collectives™ on Stack Overflow

Remove items from xml with specific date through linq to xml in C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related