慢慢來比較快

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

輸出結果：