using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Xml;
public partial class SqlToXML: System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument xml = new XmlDocument();
SqlConnection Conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString);
Conn.Open();
SqlCommand cmd = new SqlCommand("SELECT LastName, FirstName, Title FROM [Employees] FOR XML AUTO,root('root'), elements", Conn);
xml.Load(cmd.ExecuteXmlReader());
xml.Save(Server.MapPath("Employees.xml"));
}
}