Mega Code Archive

 

Categories / C# Tutorial / XML

 

Read Xml output from database

using System; using System.Collections.Generic; using System.ComponentModel; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; using System.Xml; using System.IO; using System.Diagnostics;     public class MainClass     {         public static void Main()         {             SqlConnection cnn = new SqlConnection(@"data source=.\sqlexpress;initial catalog=northwind;integrated security=true");             SqlCommand cmd = new SqlCommand();             cmd.Connection = cnn;             cmd.CommandType = CommandType.Text;             cmd.CommandText = "select * from Employee FOR XML AUTO";             cnn.Open();             XmlReader reader=cmd.ExecuteXmlReader();             StreamWriter writer= File.CreateText(Application.StartupPath + @"\temp.xml");             writer.Write("<root>");             while (reader.Read())             {                 writer.Write(reader.ReadOuterXml());             }             writer.Write("</root>");             writer.Close();             reader.Close();             cnn.Close();             Process.Start(Application.StartupPath + @"\temp.xml");         }     }