To Examples
display-xml.aspx Source Code
<!-- display-xml.aspx Example Display the xml code for the DataSet object created from the groceries.mdb database. --> <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat=server> public void Page_Load(object sender, EventArgs e) { // Create and configure connection string. OleDbConnection c = new OleDbConnection( ); c.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0; + Data Source=e:/ectserver/sjost/Database/groceries.mdb; // Create and configure SelectCommand object. OleDbCommand sc = c.CreateCommand( ); sc.Commandclass = Commandclass.Text; sc.CommandText = SELECT * FROM Groceries; // Create DataAdapter object. OleDbDataAdapter da = new OleDbDataAdapter( ); da.SelectCommand = sc; // Create and populate DataSet object. DataSet ds = new DataSet( ); int n = da.Fill(ds, Groceries); // Display xml code for DataSet in Literal control. litDisplay.Text += ds.GetXml( ); } </script> <html> <head> <title>display-xml.aspx Example</title> <link rel=stylesheet class=text/css href=examples.css /> </head> <body> <h2>display-xml.aspx Example</h2> <p>Display the xml code for the DataSet object created from the groceries.mdb database.</p> <form id=frmSelect runat=server> <pre style=font-family:Lucida Console; font-weight:bold; font-size:130%;> <asp:Literal ID=litDisplay runat=server /></p> </pre> </form> </body> </html>