how to retrieve and display XML using C#?

well the problem is that I am new to asp.net technology and I am stuck on a problem.

Now the scenario is that I have to send an HTTPrequest to another server from my page, lets say myGames.aspx and in response to the request the server sends me an XML file. Now I don't know how to handle this situation, I mean I am like a total noob :(

also I don't have just to display the data, I have to send different fields of the XML to different databse tables, but thats a later issue, I'd first like to play with the XML data just on screen.

Re: how to retrieve and display XML using C#?

Hi,

Just follow this link

http://www.hookedonlinq.com/LINQtoXML5MinuteOverview.ashx

http://www.mssqltips.com/sqlservertip/1524/reading-xml-documents-using-linq-to-xml/

i hope it helps you

Re: how to retrieve and display XML using C#?

I googled and tried a lots of approaches but the problem is that my browser isn't displaying the the XML. I just can't catch the data in XML format. if I convert it to string then its printed just fine, but I dont want that, all I want is a solution to HOW TO HANDLE THE RESPONDED BACK XML FILE AS A RESULT OF HTTP REQUEST.

Re: how to retrieve and display XML using C#?

Hello,

Which browser you are using IE is Support XML file it will display the xml result.

suppose if you are using any handlers

use this line

context.Response.ContentType = "text/xml";

it ll give you the xml result.

Re: how to retrieve and display XML using C#?

No I dont know how to use handlers

Re: how to retrieve and display XML using C#?

Hello,

How you send the requset to different server?

would you please post what you get the respose from that server.

it ll easy to guide you.

Re: how to retrieve and display XML using C#?

string url = "http://example.com/CDATA";
				
				WebRequest req = HttpWebRequest.Create("http://example.com/CDATA");
				WebResponse res = req.GetResponse();

				StreamReader sr = new StreamReader(res.GetResponseStream());
				string str = sr.ReadToEnd();
				
                
                XmlReaderSettings readerSettings = new XmlReaderSettings();
                readerSettings.IgnoreWhitespace = true;
                XmlReader reader = XmlReader.Create(sr);
                //XmlReader reader = XmlReader.Create(str);
                //XmlReader reader = XmlReader.Create(url);
                Response.Write(reader);

it simply gives an error when I try to use the str argument

and this below is the outoput that I get

System.Xml.XmlTextReaderImpl

Re: how to retrieve and display XML using C#?

Hello,

You need to create the handler for like this

http://www.dotnetperls.com/ashx

and then create you what ever yiou want

import thing is you need to add

context.Response.ContentType = "text/xml";

Re: how to retrieve and display XML using C#?

Follow this link

http://www.4guysfromrolla.com/articles/092403-1.aspx#postadlink

Re: how to retrieve and display XML using C#?

please see this

http://www.codeproject.com/Articles/7718/Using-XML-in-C-in-the-simplest-way

Re: how to retrieve and display XML using C#?

mamoorkhan
Now the scenario is that I have to send an HTTPrequest to another server from my page, lets say myGames.aspx and in response to the request the server sends me an XML file. Now I don't know how to handle this situation, I mean I am like a total noob :(

There are mainly three ways

1If your xml is very regularyou can use DataSet.ReadXml to read all the things in and then deal with the DataTable inside the DataSet

2Use XmlDocument

3Use XDocument

Reguards

Re: how to retrieve and display XML using C#?

I'm bumping this thread because it's really similar to what I'm also trying to figure out. Here is the code I'm testing:

using System;
using System.Xml;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleLINQtoXML
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create the query
            var records = from c in XElement.Load("xmlTest.xml").Elements("record")
                          select c;

            //Execute the query
            foreach (var record in records)
            {
                Console.WriteLine(record);
            }

            //Pause the application
            Console.ReadLine();
        }
    }
}

And here is some of the XML I'm trying to read from:

<?xml version="1.0" encoding="UTF-8" ?>
<xml>
  <records>
    <record>
      <database name="CMF 2011 Copy 3.enl" path="C:\Users\Ellen Van Alstyne\Documents\SRI writing\TraumaLine or spineline summaries from Aaron\TL and SL and CMFL arrived 7-13-2011\CMF 2011 Copy 3.enl">CMF 2011 Copy 3.enl</database>
      <source-app name="EndNote" version="14.0">EndNote</source-app>
      <rec-number>1</rec-number>
      <foreign-keys>
        <key app="EN" db-id="9p5z2tt9iddpaxeaxpdxrrr00vwx29zxedfx">1</key>
      </foreign-keys>
      <ref-type name="CMFDiagnosis">53</ref-type>
      <contributors>
        <authors>
          <author>
            <style face="normal" font="default" size="100%">Bhagol, A.</style>
          </author>
          <author>
            <style face="normal" font="default" size="100%">Singh, V.</style>
          </author>
          <author>
            <style face="normal" font="default" size="100%">Kumar, I.</style>
          </author>
          <author>
            <style face="normal" font="default" size="100%">Verma, A.</style>
          </author>
        </authors>
      </contributors>

If I set .Elements("record") to .Elements("records"), this program will return everything. But If I set it TO ANYTHING ELSE, it will return nothing.

All I want to do it pull out the individual author names, and save them somewhere I can access them. How can I do this? None of these sources are helping at all, because for some reason I can't return any of the values from my XML. For example, var authorName = Element("author").Value;....does not work.

Thanks.