Importing data from XML file to strings

Question

I have been searching for an answer for 24 hours, but I did not find it. I am new to C#. I have found a tutorial, from where I have used this code:

XDocument loadedCustomData = XDocument.Load("PeopleCustom.xml");
var filteredData = from c in loadedCustomData.Descendants("Person")
                           where c.Attribute("Age").Value == current.ToString()
                           select new Person
                           {
                               FirstName = (string)c.Attribute("FirstName").Value,
                           };

listBox1.ItemsSource = filteredData;
public class Person
    {
        string firstname;
        string lastname;
        int age;

        public string FirstName
        {
            get { return firstname; }
            set { firstname = value; }
        }

        public string LastName
        {
            get { return lastname; }
            set { lastname = value; }
        }


        public int Age
        {
            get { return age; }
            set { age = value; }
        }


    }

XML is like this:

<People>
<Person
   FirstName="Kate"
   LastName="Smith"
   Age="1" />
<Person 
       ...
               />
</People>

It works, but it puts all output into listbox. I want strings. I tried to get string from list box (like this listBox1.Items[0].ToString();), but all I get is something like this: ProjectName.MainPage+Person. I also tried to get it from filteredData, but no success. Is there any way to get data from XML to strings? Thank you in advance for your answer

Muad'Dib · Accepted Answer · 2012-01-31 02:46:51Z

1

this code

XDocument loadedCustomData = XDocument.Load("PeopleCustom.xml");
var filteredData = from c in loadedCustomData.Descendants("Person")
                           where c.Attribute("Age").Value == current.ToString()
                           select new Person
                           {
                               FirstName = (string)c.Attribute("FirstName").Value,
                           };

makes a list of Person objects: select New Person{.....}

If you want a list of string of the Person's first name, then all you have to do is change what object the LINQ is creating....

select (string)c.Attribute("FirstName").Value );

now, it makes a new string from the FirstName attribute.

after this linq is run, you will basically have a linq object that will produce a list of strings. if you want a List then modify like this:

XDocument loadedCustomData = XDocument.Load("PeopleCustom.xml");
var filteredData =( from c in loadedCustomData.Descendants("Person")
                           where c.Attribute("Age").Value == current.ToString()
                           select (string)c.Attribute("FirstName").Value ).ToList();

if you want the first string in the list...

filterdData.First();

edited Jan 31, 2012 at 2:46

answered Jan 31, 2012 at 2:11

Muad'Dib

29.4k5 gold badges58 silver badges71 bronze badges

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

2 Comments

Nikmaster Over a year ago

Sorry, I cant vote up your answer, I do not have enough rep. Thanks again

Nikmaster Over a year ago

Is there any way to convert filteredData directly to string, without using listbox? filteredData.ToString(); is not working

scartag · Accepted Answer · 2012-01-31 08:36:28Z

0

From the output you are getting listBox1.items contains person objects so you could try

var name = ((Person)listBox1.Items[0]).FirstName;

this should give you the value

edited Jan 31, 2012 at 8:36

answered Jan 31, 2012 at 2:16

scartag

17.7k3 gold badges52 silver badges53 bronze badges

1 Comment

Nikmaster Over a year ago

Sorry, this did not work. It says that there is no definition for Firstname.

Collectives™ on Stack Overflow

Importing data from XML file to strings

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related