writexml.aspx

asp.net技术内幕的书配源码

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script runat=server>
void Page_Load(Object sender , EventArgs e) 
{
  SqlConnection conPubs;
  SqlDataAdapter dadTitles;
  DataSet dstTitles;

  conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Pubs" );
  dadTitles = new SqlDataAdapter( "Select * From Titles", conPubs );
  dstTitles = new DataSet();
  dadTitles.Fill( dstTitles, "Titles" );

  dstTitles.WriteXml( "c:\\myXml.xml" );
  Response.Write( "Saved myXml.xml file!" );
}
</Script>