Hello community im new! I am really rusty at C# but i do not want to learn the basics all over again so i hit the ground running and ran into a hurdle. I want to use an xml file for a database. Its a car repair tracking system i am working on so this is not the initial file buy you'll get the idea:

	<car Id="1">
	<name>Mr Thompson</name>
	<status>Ready for pickup</status>

	<car Id="2">
	<name>Mr Simpson</name>
	<status>in progress</status>

What i want is the C# asp.net application to pick up the xml nodes by the car id. However I do not know how to pick up the value of the id through XmlReader (maybe one of you know a better method, but im working with this for now until i find something better.) I have made a program however it only picks up the first set of tags, the Mr Thompson ones, What i want to know is how do i set it so it can pick up the first set when I enter id=1 and pick up the second set when i enter id=2. here is the code i am working with:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
    string name;
    string model;
    string address;
    protected void Page_Load(object sender, EventArgs e)
        Response.Write("hello world");

    protected void Button1_Click1(object sender, EventArgs e)
        XmlTextReader xmlReader = new XmlTextReader(Server.MapPath("vehix.xml"));

        int intId = 1;
        //   int intCar = 0;

        while (xmlReader.Read())
            if (xmlReader.Name.ToString() == "car")
                if (xmlReader.HasAttributes)
                    while (xmlReader.MoveToNextAttribute())
//                        if (xmlReader.Name == "Id")
//                        {
//                           intId = 1;

//                        }
            if (xmlReader.Name.ToString() == "name") name = xmlReader.ReadString().Trim();
            if (xmlReader.Name.ToString() == "model") model = xmlReader.ReadString().Trim();
            if (xmlReader.Name.ToString() == "address") address = xmlReader.ReadString().Trim();

        TextBox1.Text = name;
        TextBox2.Text = model;
        TextBox3.Text = address;

so basically all i want to know is how to pick up the id number of the xml tag id, i can incorporate the rest myself or until i run into more problems and come back.

thank you

7 Years
Discussion Span
Last Post by __avd

Use Xml LINQ.

using System;
using System.Xml.Linq;

class Test
 static void Main()
   string path = @"c:\path1\sample.xml";
   XDocument doc = XDocument.Load(path);
   foreach (var t in doc.Descendants("car"))
          Console.WriteLine(t.Attribute("Id").Value );
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.