Fetching Data from a Database in XML Format

In this article we will see how to fetch data from database in XML format.

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;

                             //

                    }

          }

}