using System;
using System.Data;
using System.Xml;
using System.Data.SqlClient;
using System.IO;

public class TestWriteXML
{
public static void Main()
{

String strFileName=c:/temp/output.xml;

SqlConnection conn = new SqlConnection(server=localhost;uid=sa;pwd=;database=db);

String strSql = SELECT FirstName, LastName FROM employees;

SqlDataAdapter adapter = new SqlDataAdapter();

adapter.SelectCommand = new SqlCommand(strSql,conn);

// Build the DataSet
DataSet ds = new DataSet();

adapter.Fill(ds, employees);

// Get a FileStream object
FileStream fs = new FileStream(strFileName,FileMode.OpenOrCreate,FileAccess.Write);

// Apply the WriteXml method to write an XML document
ds.WriteXml(fs);

fs.Close();

}
}

//csharp/1136