To Examples
grocery-display3.aspx Source Code
<!-- grocery-display3.aspx Example Display the on sale items from the groceries.mdb database in a DataGrid control. Pick a select statement for choosing which data to display. --> <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat=server> public void SelectHandler(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 = ddlSelect.SelectedValue; // 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 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 class=text/css> td { padding-left:0.15cm; padding-right:0.15cm; padding-top:0.15cm; padding-bottom:0.15cm; } </style> </head> <body> <h2>grocery-display3.aspx Example</h2> <p>Display the on sale items from the groceries.mdb database in a DataGrid control.<br /> Pick a select statement for choosing which data to display.</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% /> </pre> </form> </body> </html>