To Examples
persons-display.aspx Source Code
<!-- persons-display.aspx Example Use an AccessDataSource object to manage the Connection and DataAdapter objects. Display rows from the Persons table where age interval and gender are specified by the user. --> <%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat=server> public void btnSubmit_Click(object sender, EventArgs e) { // Define new sql statement. string sql = SELECT * FROM Persons WHERE + Age > + txtMinAge.Text + And + Age < + txtMaxAge.Text + And + Gender = ' + ddlGender.SelectedValue.ToString( ) + ';; litSql.Text = sql; adsGroceries.SelectCommand = sql; // Display data in DataGrid object. dgGroceries.DataSource = adsGroceries; 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>persons-display.aspx Example</h2> <p>Use an AccessDataSource object to manage the Connection and DataAdapter objects.<br /> Display rows from the Persons table where age interval and gender are specified by the user.</p> <form id=frmSelect runat=server> <asp:AccessDataSource ID=adsGroceries runat=server DataFile=e:/ectserver/sjost/Database/persons.mdb SelectCommand=SELECT * FROM Persons;> </asp:AccessDataSource> <table> <tr> <td>Minimum Age</td> <td><asp:TextBox runat=server Id=txtMinAge Width=200px /> </tr> <tr> <td>Maximum Age</td> <td><asp:TextBox runat=server Id=txtMaxAge Width=200px /> </tr> <tr> <td>Gender</td> <td><asp:DropDownList runat=server Id=ddlGender Width=200px> <asp:ListItem Value=F>Female</asp:ListItem> <asp:ListItem Value=M>Male</asp:ListItem> </asp:DropDownList> </tr> <tr> <td> </td> <td><asp:Button runat=server Id=btnSubmit Width=200px Text=Submit Query OnClick=btnSubmit_Click /> </tr> </table> <p> <asp:Literal runat=server Id=litSql /> </p> <p> <asp:DataGrid ID=dgGroceries runat=server AutoGenerateColumns=True style=font-size:90% /> </p> </form> </body> </html>