LINQ to XML in ASP.NET 3.5
Introduction
In this article, we will be looking at another flavor of Microsoft's new introduction to the .NET Framework, LINQ to XML. LINQ (Language-Integrated Query) comes in a variety of forms, including LINQ to SQL and LINQ to Objects. In this article, we will be looking at LINQ to XML in Visual Studio.NET 2008. If you do not have 2008, you can download the LINQ Preview for VS.NET 2005 direct from Microsoft.
We chose Server Intellect for its dedicated servers, for our web hosting. They have managed to handle virtually everything for us, from start to finish. And their customer service is stellar.
For this demonstration, we will be using LINQ to XML in a Windows Form to display data from an XML file, and then also having the ability to add new data to the XML file.
What we will learn in this article:
- How to retrieve data from an XML file using LINQ;
- How to add data to an XML file using LINQ.
Please Note:
LINQ is integrated into ASP.NET 3.5 and does not require any additional downloads. If you are using ASP.NET 2.0, certain extra steps may need to be taken that are not covered in this article.
Getting Started
The first thing we will need to do is create the XML file we will be using. So let's go ahead and open up Visual Studio and create a new C# Windows Form Application. Once opened, right-click the project in Solution Explorer and choose Add > New Item.. XML File. Name it Players.xml:
[Click to enlarge]
Once we have this opened in Visual Studio, we will need to build the structure of the file. For this example, we will use soccer player names, their teams, and their positions. The structure of the XML file will look like this:
We migrated our web sites to Server Intellect over one weekend and the setup was so smooth that we were up and running right away. They assisted us with everything we needed to do for all of our applications. With Server Intellect's help, we were able to avoid any headaches!
Our XML file needs to be correctly structured. Each player resides within the
Once we have completed our XML file, with some sample data, we can start to build our form. We will need to display the XML file on the form, and also provide a way to add new data to the XML file.
To do this, we will add two textboxes, for the name and team elements, and then a combo box for the position element. We will use a combo box to restrict the values that can be input for this element. We will also add two buttons - one to add, and one to read, and then a richtextbox to display the contents of the XML file. Our form will looks something like this:
[Click to enlarge]
We moved our web sites to Server Intellect and have found them to be incredibly professional. Their setup is very easy and we were up and running in no time.
The large textbox at the bottom of the form is the richtextbox that will be used to display the contents of the XML file. To add options to our combo box, click the Smart Tag in design view and choose Edit Items. Then simply add the items to the box that appears (One option per line, like so:)
[Click to enlarge]
[Click to enlarge]
We should also change the names of the controls. It is good practice to name the controls you will be working with, particularly if you are going to be referencing them by name in the code-behind. As a good naming convention, name buttons beginning with but, textboxes beginning with txt and labels beginning with lbl, for example. Our textboxes on this form are named txtName and txtTeam; the combobox is named cmbPosition; the buttons are named butAdd and butReadXml; and the richtextbox is named txtResults.
Need help with Windows Dedicated Hosting? Try Server Intellect. I'm a happy customer!
In this example, we are going to create a method for adding data to the XML file, and another method to read the data from the XML file. We can then call these methods from the button click events. This allows us to use the methods more than once, yet only have one instance.
If we double-click one of our buttons on the form design view, we will create an event handler for the click event of that button. We can do it for both buttons and have the following code-behind:
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Xml.Linq;
using System.Text;
using System.Windows.Forms;
using System.Linq;
namespace example
{
{
{
private void butAdd_Click(object sender, EventArgs e)
{
}
private void butReadXML_Click(object sender, EventArgs e)
{
}
Once we have the handlers created, we will create our own methods starting with the readXml method. We will be using LINQ to first load the XML file, and then select all data before looping through the collection to display in the richtextbox. The method is displayed below.
NOTE: When developing and debugging the application in Visual Studio, the programm will not be able to locate the XML file if it is placed in the root directory. To avoid this, copy the XML file to the bin/debug folder when running from Visual Studio.
I just signed up at Server Intellect and couldn't be more pleased with my Windows Server! Check it out and see for yourself.
{
var players = from player in xmlDoc.Descendants("Player")
{
Team = player.Element("Team").Value,
Position = player.Element("Position").Value,
txtResults.Text = "";
foreach (var player in players)
{
txtResults.Text = txtResults.Text + "Team: " + player.Team + "\n";
txtResults.Text = txtResults.Text + "Position: " + player.Position + "\n\n";
if (txtResults.Text == "")
There were times in the past when simply parsing an XML file would take many lines of code, but LINQ makes it so easy for us, that we can loop through a file, collect all data within, and display it into a textbox in as few as 15 lines of code.
Adding data to an XML file using LINQ is even easier than reading; we simply need to load the XML file and specify where and what we want to add. Finally, we can save the changes to the XML file. The method to add new data to the XML file is below.
{
xmlDoc.Element("Players").Add(new XElement("Player", new XElement("Name", txtName.Text),
xmlDoc.Save("Players.xml");
readXml();
These two methods will successfully manage our XML data. We can call these methods from our button clicks like so:
Server Intellect offers Windows Hosting Dedicated Servers at affordable prices. I'm very pleased!
{
private void butReadXML_Click(object sender, EventArgs e)
{
What we have Learned
We have learned how to use LINQ to XML to manipulate XML by loading external XML files and reading the data within, as well as writing data to external XML files also.
Attachments
|
|