To Examples
GroceriesXml Example, source code file groceries3.aspx
<%@ Page Language="C#" %> <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <!-- GroceriesXml Example Display dataset as Xml. View source code of browser to see the Xml code. --> <script runat="server"> public void Page_Load(object sender, EventArgs e) { // Create and configure connection string. OleDbConnection c = new OleDbConnection( ); c.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=e:/ectserver/sjost/Database/groceries.accdb;"; // Create Command object with query from drop down list. OleDbCommand sc = new OleDbCommand("SELECT * FROM Groceries;", c); // Create DataAdapter object. OleDbDataAdapter da = new OleDbDataAdapter(sc); // Create and populate DataSet object. DataSet ds = new DataSet( ); int n = da.Fill(ds, "Groceries"); // Display dataset as Xml. litXml.Text = ds.GetXml(); } </script> <html> <head> <title>GroceriesXml Example</title> <link rel="stylesheet" class="text/css" href="../examples.css" /> <style type="text/css"> td { padding-left:0.15cm; padding-right:0.15cm; padding-top:0.15cm; padding-bottom:0.15cm; } </style> </head> <body> <h2>GroceriesXml Example</h2> <p>Display the dataset as an Xml file. View source code of browser to see the Xml code. </p> <form id="frmSelect" runat="server"> <pre> <asp:Literal ID="litXml" runat="server" /> </pre> </form> </body> </html>