getxmlschema.aspx

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

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

<script runat=server>
string strTableName = "Titles";
 
void Page_Load(Object sender , EventArgs e) 
{
  SqlConnection conPubs;
  SqlDataAdapter dadDataAdapter;
  DataSet dstDataSet;
  string strXmlSchema;

  conPubs = new SqlConnection( @"Server=localhost;Integrated Security=SSPI;Database=Pubs" );
  dadDataAdapter = new SqlDataAdapter( "Select * From " + strTableName, conPubs );
  dstDataSet = new DataSet();
  dstDataSet.DataSetName = strTableName + "DS";
  dadDataAdapter.Fill( dstDataSet, strTableName );

  strXmlSchema = Server.HtmlEncode( dstDataSet.GetXmlSchema() );
  Response.Write( "<pre>" + strXmlSchema + "</pre>" );
}

</Script>