• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

ASP.Net/C# - If I have a URL that dumps XML, how do I read those results in?

Is there an easy way to read in results of an XML file URL and output the elements as the label and values?
0
sbornstein2
Asked:
sbornstein2
  • 3
  • 2
1 Solution
 
codeclayCommented:
See the sample code attached below
####################################Code Behind########################
public partial class XML : System.Web.UI.Page
{
    TextBox textBoxValue;
    Label lblValue;
    Table tbl;
    TableRow tr;
    TableCell td;
    protected void Page_Load(object sender, EventArgs e)
    {
        
 
    }
    protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        tbl = new Table();
 
        LoadXML();
    }
    private void LoadXML()
    {
        XmlDocument doc = new XmlDocument();
        doc.Load(XmlReader.Create("http://localhost/Test/Sample.xml"));
        CreateChildControlsFromXML(doc);
    }
 
    private void CreateChildControlsFromXML(XmlDocument doc)
    {
        foreach (XmlNode node in doc.ChildNodes)
        {
            if (node.NodeType == XmlNodeType.Element && node.Name == "Elements")
            {
                foreach (XmlNode node1 in node.ChildNodes) // Get the value Nodes
                {
                    tr = new TableRow();
                    td = new TableCell();
                    lblValue = new Label();
                    textBoxValue = new TextBox();
                    lblValue.Text = node1.ChildNodes[0].InnerText;
                    textBoxValue.Text = node1.ChildNodes[1].InnerText;
                    td.Controls.Add(lblValue);
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.Controls.Add(textBoxValue);
                    tr.Cells.Add(td);
                    tbl.Rows.Add(tr);
                }
            }
        }
        containerPanel.Controls.Add(tbl);
    }
}
##################################Code Behind End#####################
 
#######################ASPX########################################
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="XML.aspx.cs" Inherits="XML" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <asp:Panel runat="server" ID="containerPanel"></asp:Panel>
    </div>
    </form>
</body>
</html>
 
#######################ASPX END########################################
 
###########################Sample XML file Used#######################
 
<?xml version="1.0" encoding="utf-8"?>
<Elements>
  <Value>
    <Label>Label1</Label>
    <Text>Text1</Text>
  </Value>
  <Value>
    <Label>Label2</Label>
    <Text>Text2</Text>
  </Value>
  <Value>
    <Label>Label3</Label>
    <Text>Text3</Text>
  </Value>
  <Value>
    <Label>Label4</Label>
    <Text>Text4</Text>
  </Value>
</Elements>

Open in new window

0
 
sbornstein2Author Commented:
code clay that gave me a little start.  It is having issues though.  Here is what I am trying to format by reading in the XML like a HTML file.  It is a whitepages api call that I make and it returns XML data

http://api.whitepages.com/reverse_phone/1.0/?phone=7812332311;api_key=9ec586766bf2c9b0bd5f548a50a0b3e2

I need to somehow read this in and it may change and have more nodes etc.
0
 
sbornstein2Author Commented:
on whitepages.com there is an XSD file but I have no idea how to use all that.  I can just get the XML response

http://developer.whitepages.com/docs
0
 
codeclayCommented:
I will look into it.. Right now its a busy schedule for me . Hold on .
0
 
sbornstein2Author Commented:
thanks sorry for the delay in award.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now