getxml.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;
	string strXmlData;

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

	strXmlData = dstTitles.GetXml();
	Response.Write( "<pre>" + Server.HtmlEncode( strXmlData ) + "</pre>" );
}

</Script>