To Examples
Groceries1 Example, source code file groceries1.aspx
<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <!-- Groceries1 Example Display items from the groceries.mdb database in a DataGrid control. Pick a select statement for choosing which data to display. --> <script runat="server"> public void SelectHandler(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(ddlSelect.SelectedValue, 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 data in DataGrid object. dgGroceries.DataSource = ds; dgGroceries.DataBind( ); } </script> <html> <head> <title>grocery-display3.aspx 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>Groceries1 Example</h2> <p>Display from the groceries.mdb database in a DataGrid control.<br /> Choose a select statement to control which data is displayed.</p> <form id="frmSelect" runat="server"> <p> <asp:DropDownList runat="server" ID="ddlSelect" AutoPostBack="true" OnSelectedIndexChanged="SelectHandler" style="font-size:120%"> <asp:ListItem>SELECT * FROM Groceries;</asp:ListItem> <asp:ListItem>SELECT Item, Price FROM Groceries;</asp:ListItem> <asp:ListItem>SELECT Item, Price FROM Groceries WHERE OnSale=True;</asp:ListItem> <asp:ListItem>SELECT Price, Quantity FROM Groceries WHERE Item='Dog Food';</asp:ListItem> <asp:ListItem>SELECT Item, Price FROM Groceries WHERE Price > 3.00;</asp:ListItem> <asp:ListItem>SELECT Item, Price FROM Groceries WHERE 1.00 <= Price AND Price<=3.50;</asp:ListItem> </asp:DropDownList> </p> <asp:DataGrid ID="dgGroceries" runat="server" style="font-size:90%" /> </form> </body> </html>