Fetching Data from a Database in XML Format

Ashish Singhal

elementsDatabase QueryXmlReaderAutoxmldata format

6 Comments

Join the conversation! Your thoughts help the community grow.

Subash10y ago
Nice one
basit abdul16y ago
i want to create a report using sql server reporting services 2008 and pupblish to my website at a regular interval. I can create the reports but my problem is how to make it available on my website. currently, it is a static report which i manually copy and past on the site. Help me please.
saroer azam16y ago
I wanna use this in asp.net. Can you please provide me a modification for asp.net and mysql?
shaveta mehta19y ago
HI Can u plz tell me How to fetch data from database in SQL Format. Thanks
Jayanta Dutta21y ago
hi ashish, Thanks very much for the article. I have done as you had writen in the article. but i am not getting XmlReader reader = cmd.ExecuteXmlReader();.instead it gives me XmlReader reader = cmd.ExecuteReader();. Can you tell me what is the raeson behind it? Note: i have included System.Xml and i am using oracleClient and i have included all the namespaces necessary for that. Jayanta
- Ashish Singhal21y agoedited
  Hi, I used this in Framework 2.0 , probably you are using in 1.0 so its extended in 2.0 now. Thanks, Ashish

Here we will see that how can we fetch data from database in XML format.

using System;

using System.Data.SqlClient;

using System.Xml;

namespace test

{

/// <summary>

/// Summary description for Class1.

/// </summary>

class ReadXML

{

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main(string[] args)

{

string connectionString = "server=.;uid=test;pwd=test;database=test";

SqlConnection con = new SqlConnection(connectionString);

SqlCommand cmd = new SqlCommand("select * from test for xml auto, elements", con);

con.Open();

XmlReader reader = cmd.ExecuteXmlReader();

con.Close();

XmlDocument doc = new XmlDocument();

doc.LoadXml("<root></root>");

XmlNode node = doc.ReadNode(reader);

while(node != null)

{

Console.WriteLine(node.InnerXml);

node = doc.ReadNode(reader);

}

reader.Close();

reader = null;

doc = null;

}