Read Write and Search an XML File Data in Windows Phone 7

In this article we will discuss how to easily Read, Write and Search Data in a XML File. Here we use two buttons, the first button will show XML file data in a ListBox like this:

And when we click on the Search Name Button:

Step 1

First we create two XML files like this:

Student.xml

<?xml version="1.0" encoding="utf-8" ?>

<firstname>Mahak</firstname>

<lastname>Gupta</lastname>

</student>

<firstname>Khyati</firstname>

<lastname>Jindal</lastname>

</student>

<firstname>Megha</firstname>

<lastname>Varshney</lastname>

</student>

<firstname>Meghal</firstname>

</student>

</school>

StudentData.xml

<?xml version="1.0" encoding="utf-8" ?>

<Student

FirstName="Mahak"

LastName="Gupta"

Age="27" />

<Student

FirstName="Khyati"

LastName="Jindal"

Age="5" />

<Student

FirstName="Megha"

LastName="Varshney"

Age="27" />

<Student

FirstName="Meghal"

LastName="Dani"

Age="22" />

</School>

Step 2

Now we will write the code in our .xaml page like this:

<ListBox.ItemTemplate>

</StackPanel>

</DataTemplate>

</ListBox.ItemTemplate>

<ListBox.Background>

</LinearGradientBrush>

</ListBox.Background>

</ListBox>

<ListBox.ItemTemplate>

</StackPanel>

</DataTemplate>

</ListBox.ItemTemplate>

<ListBox.Background>

</LinearGradientBrush>

</ListBox.Background>

</ListBox>

</Grid>

The output will be:

Step 3

Now we will write the code for the "Show data" button:

private void button1_Click(object sender, RoutedEventArgs e)

{

lstShow.Visibility = Visibility.Visible;

txtSearch.Visibility = Visibility.Collapsed;

btnSearch.Visibility = Visibility.Collapsed;

lstSearchName.Visibility = Visibility.Collapsed;

XDocument myData = XDocument.Load("Student.xml");

var data = from query in myData.Descendants("student")

select new Student

{

FirstName = (string)query.Element("firstname"), LastName = (string)query.Element("lastname"), Age = (int)query.Element("age")

};

lstShow.ItemsSource = data;

}

Here we create a class like this:

public class Student

{

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; }

}

So the output will be:

Step 4

Now we will write the code for the "Search name" button, so when we click on this button a TextBox (txtSearch) and a Search button will be shown like this:

private void btnSearchname_Click(object sender, RoutedEventArgs e)

{

txtSearch.Visibility = Visibility.Visible;

btnSearch.Visibility = Visibility.Visible;

lstShow.Visibility = Visibility.Collapsed;

}

Now we will write the code for the Search Button like this:

private void btnSearch_Click(object sender, RoutedEventArgs e)

{

XDocument LoadStudentData = XDocument.Load("StudentData.xml");

var SearchData = from c in LoadStudentData.Descendants("Student")

where c.Attribute("FirstName").Value == txtSearch.Text.ToString()

select new Student()

{

FirstName = c.Attribute("FirstName").Value,

LastName = c.Attribute("LastName").Value

};

lstSearchName.ItemsSource = SearchData;

lstSearchName.Visibility = Visibility.Visible;

}

The output will be: