Linq to XML: .Net Windows Forms, XML query

Question

I am trying to create a customer record which would include First Name, Last Name, SSN and Date of Birth. When a user selects a customer from the combobox (cboCustomer), it calls the SelectedIndexChanged event. I want to use the selected index to get the correct customer record from my XML.

Here is the query I've created, but it is empty. Below the query is my XML data source.

    private void cboCustomer_SelectedIndexChanged(object sender, EventArgs e)
    {
        var doc = XElement.Load("Portfolio.xml");
        customerId = cboCustomer.SelectedIndex.ToString();
        if (cboCustomer.SelectedIndex != 0)
        {
            var custRecord =
                from account in doc.Descendants("account")
                let acct = account.Element("acct")
                where (string)account.Element("custid") == customerId
                select new
                {Fname=(string)account.Element("fname"),
                    Lname = (string)account.Element("lname"),
                    Ssn = (string)account.Element("ssn"),
                    Dob = (string)account.Element("dob")
                };
        }
    }

svick · Accepted Answer

There is no element custid in your XML, but you're looking for it in your code.

You probably want

where acct.Attribute("custid").Value == customerId

And you need to modify your select in a similar way.

Linq to XML: .Net Windows Forms, XML query

Answers (1)

Related Questions