using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlXml;
using System.IO;
public class MainClass
{
public static void Main()
{
string strConn = @"Provider=SQLOLEDB;server=.\sqlexpress;database=northwind;integrated security=SSPI";
SqlXmlCommand cmd = new SqlXmlCommand(strConn);
cmd.CommandText = "select EmployeeID,FirstName,LastName from employees for xml auto";
cmd.RootTag = "root";
cmd.XslPath = Application.StartupPath + @"\employees.xslt";
StreamWriter writer = File.CreateText(Application.StartupPath + @"\sqlxmlresults.htm");
cmd.ExecuteToStream(writer.BaseStream);
writer.Close();
}
}
|