To Examples
PersonInfo Example, source code file person-info3.aspx
<%@ Page Language="C#" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <!-- PersonInfo3 Example Submit age, gender, and age for a person; store this information in a database. Retrieve this data with the ViewPersons page. --> <script runat="server"> public void btnSubmit_Click(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/persons-data.accdb;"; // Open connection. c.Open(); // Get data from textboxes. string lastName = txtLastName.Text; string firstName = txtFirstName.Text; string gender = txtGender.Text; int age = int.Parse(txtAge.Text); // Compose SQL command string. string sql = "INSERT INTO Persons VALUES" + "('" + lastName + "', '" + firstName + "', '" + gender + "'," + age + ");"; // Show SQL insert statement. litMessage.Text = "Data submitted with SQL query string<br />" + sql; // Create command object and execute insert statement. OleDbCommand command = new OleDbCommand(sql, c); command.ExecuteNonQuery(); // Close connection. c.Close(); } </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>PersonInfo3 Example</h2> <p>Submit age, gender, and age for a person; store this information in a database. Retrieve this data with the ViewPersons page. </p> <form id="frmSelect" runat="server"> <table> <tr> <td class="r">Last Name</td> <td><asp:TextBox ID="txtFirstName" runat="server" CssClass="ctrl" /></td> </tr> <tr> <td class="r">First Name</td> <td><asp:TextBox ID="txtLastName" runat="server" CssClass="ctrl" /></td> </tr> <tr> <td class="r">Gender</td> <td><asp:TextBox ID="txtGender" runat="server" CssClass="ctrl" /></td> </tr> <tr> <td class="r">Age</td> <td><asp:TextBox ID="txtAge" runat="server" CssClass="ctrl" /></td> </tr> <tr> <td> </td> <td><asp:Button ID="btnSubmit" runat="server" Text="Submit" CssClass="ctrl" Width="128px" OnClick="btnSubmit_Click" /></td> </tr> </table> <p><asp:RangeValidator Type="Integer" runat="server" ControlToValidate="txtAge" Display="Static" MinimumValue="0" MaximumValue="130" ErrorMessage="Age must be between 0 and 130" /></p> <p><asp:Literal ID="litMessage" runat="server" /></p> </form> </body> </html>