How to Retrieve XML using Linq Lambda?

Question

When Databind() calls, It generates error at new Customers. Please solve it only by linq with lambda.

The Error :

object reference not set to an instance of an object

IEnumerable<Customers> Customers = XDocument.Load("Customers.xml")
    .Descendants("Customer")
        .Select(x => new Customers
        {
            Name = x.Element("Name").Value,
            City = x.Element("City").Value,
            Contact = x.Element("Contact").Value
        });

grid.DataSource = Customers;
grid.DataBind();

public class Customers
{
    public Customers() { }
    public string Name { get; set; }
    public string City { get; set; }
    public string Contact { get; set; }
}

The XML :

 <?xml version="1.0" encoding="utf-8"?>
<Customers>
    <Customer>
        <Name>John</Name>
        <City>Ney York</City>
        <Contact>2233</Contact>
    </Customer>
    <Customer>
        <Name>Albert</Name>
        <City>Sydney</City>
        <Contact>4455</Contact>
    </Customer>
    <Customer>
        <Name>David</Name>
        <City>Colombo</City>
        <Contact>6677</Contact>
    </Customer>
    <Customer>
        <Name>George</Name>
        <City>London</City>
        <Contact>8899</Contact>
    </Customer>
</Customers>

<?xml version="1.0" encoding="utf-8" ?> <Customers> <Customer> <Name>John</Name> <City>Ney York</City> <Contact>2233</Contact> </Customer> <Customer> <Name>Albert</Name> <City>Sydney</City> <Contact>4455</Contact> </Customer> <Customer> <Name>David</Name> <City>Colombo</City> <Contact>6677</Contact> </Customer> <Customer> <Name>George</Name> <City>London</City> <Contact>8899</Contact> </Customer> </Customers> — Wajahat
– Wajahat, Commented Jul 31, 2012 at 8:09
@Wajahat You can edit your question to add extra information you have rather than posting comments — Paolo Moretti
– Paolo Moretti, Commented Jul 31, 2012 at 8:11

Manish Parakhiya · Accepted Answer · 2012-07-31 08:19:48Z

5

Try this..

IEnumerable<Customers> Customers = XDocument.Load("Customers.xml").Element("Customers")
  .Descendants("Customer")
    .Select(x => new Customers
    {
        Name = x.Element("Name").Value,
        City = x.Element("City").Value,
        Address = x.Element("Address").Value
    });

Hope this work.

answered Jul 31, 2012 at 8:19

Manish Parakhiya

3,8083 gold badges24 silver badges26 bronze badges

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

Comments

Niranjan Singh · Accepted Answer · 2012-07-31 08:27:37Z

0

Modify with Customers with 's'

  List<Customers> data =   XDocument.Load("Customers.xml").Descendants("Customers")
                                    .Select(x => new Customers
                                        {
                                            Name = x.Element("Name").Value,
                                            City = x.Element("City").Value,
                                            Address = x.Element("Address").Value
                                        }).ToList();

edited Jul 31, 2012 at 8:27

Niranjan Singh

18.3k2 gold badges45 silver badges76 bronze badges

answered Jul 31, 2012 at 8:05

Aghilas Yakoub

29k5 gold badges49 silver badges51 bronze badges

Collectives™ on Stack Overflow

How to Retrieve XML using Linq Lambda?

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