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");
}
}
|