dataset-direct1.axpx Source Code

dataset-direct1.aspx Source Code

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

// 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 data in Literal control.
    foreach(DataRow r in ds.Tables[Groceries].Rows)
    {   
        foreach(object cell in r.ItemArray)
        {
            litDisplay.Text += cell + , ;
        }
        litDisplay.Text += <br />;
    }
}
</script>

<html>

<head>
<title>dataset-direct1.aspx Example</title>
<link rel=stylesheet class=text/css 
                       href=examples.css />
</head>

<body>

<h2>dataset-direct1.aspx Example</h2>

<p>Display the on sale items from the groceries.mdb
   directly in a literal control by accessing the
   Tables collection of the Dataset Directly.</p>

</body>
</html>