XML ASP.Net

  1. Home
  2. ASP.Net
  3. XML
  4. Read and format XML data into HTML
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Xml" %>

    void Page_Load(object sender, EventArgs e)
    {
        //string xmlFilePath = @"C:\Employees.xml";
          string xmlFilePath = MapPath("Employees.xml");
        string employeeID = "";
        try
        {
            using (XmlReader reader = XmlReader.Create(xmlFilePath))
            {
                lblResult.Text = "Employees";
                lblResult.Text += "
    ";
                    string result;
                    while (reader.Read())
                    {
                        if (reader.NodeType == XmlNodeType.Element)
                        {
                            if (reader.Name == "employee")
                            {
                                employeeID = reader.GetAttribute("id");
                            }
                            if (reader.Name == "name")
                            {
                                lblResult.Text += "
  • " + "Employee - " + employeeID;
                                lblResult.Text += "
      ";
                                  lblResult.Text += "
    • ID - " + employeeID + "
      • ";
                              }
                              if (reader.Name == "firstName")
                              {
                                  lblResult.Text += "
    • First Name - " + reader.ReadString() + "
      • ";
                              }
                              if (reader.Name == "lastName")
                              {
                                  lblResult.Text += "
    • Last Name - " + reader.ReadString() + "
      • ";
                              }
                              if (reader.Name == "city")
                              {
                                  lblResult.Text += "
    • City - " + reader.ReadString() + "
      • ";
                              }
                              if (reader.Name == "state")
                              {
                                  lblResult.Text += "
    • State - " + reader.ReadString() + "
      • ";
                              }
                              if (reader.Name == "zipCode")
                              {
                                  lblResult.Text += "
    • Zipcode - " + reader.ReadElementContentAsInt().ToString() + "
      • ";
                              }
                          }
                          else if (reader.NodeType == XmlNodeType.EndElement)
                          {
                              if (reader.Name == "employee")
                              {
                                  //Close the open formatting tags
                                  lblResult.Text += "
    ";
                                lblResult.Text += "
    • ";
                            }
                        }
                    }
                    lblResult.Text += "
";
            }
        }
        catch (Exception ex)
        {
            lblResult.Text = "An Exception occurred: " + ex.Message;
        }
    }



    Processing the Data in an XML File


    
    

        
    

    


<%--


      
    
      Nancy
      Lee 
    
    Seattle
    WA
    98122   
  
      
    
      Jason
      Wang
    
    Vancouver
    WA
    98123   
   

--%>