1@ Import Namespace="System.Data"
1@ Import namespace="System.Data.OleDb"
1<html>
2<head>
3<title>Validating a Field</title>
4</head>
5<body>
6<form id="Form1" method="post" runat="server">
7<table border="0" cellpadding="0" cellspacing="0" id="Table1" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" width="300">
8<tr>
9<td style="WIDTH: 115px">
10<asp:label id="Label1" runat="server">Category Name</asp:label>
11</td>
12<td>
13<asp:textbox id="txtCategoryName" runat="server" width="193"></asp:textbox>
14</td>
15</tr>
16<tr>
17<td style="WIDTH: 115px">
18<asp:label id="Label2" runat="server">Description</asp:label>
19</td>
20<td>
21<asp:textbox id="txtDescription" runat="server" width="193"></asp:textbox>
22</td>
23</tr>
24<tr>
25<td colspan="2" style="WIDTH: 115px">
26<asp:button id="btnInsert" onclick="btnInsert_Click" runat="server" text="INSERT!" width="298"></asp:button>
27</td>
28</tr>
29</table>
30<asp:requiredfieldvalidator controltovalidate="txtCategoryName" errormessage="Please insert the new category name" id="rfvCategoryName" runat="server" style="Z-INDEX: 102; LEFT: 316px; POSITION: absolute; TOP: 14px"></asp:requiredfieldvalidator>
31</form>
32</body>
33</html>
1<script language="c#" runat="server">
2OleDbConnection objConnection;
3
4private void Page_Load(object sender, System.EventArgs e)
5{
6string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
7strConnection += @"data source=\\\genfs1\www11\etning\xml\Northwind.mdb";
8}
9
10private void btnInsert_Click(object sender, System.EventArgs e)
11{
12if (Page.IsValid)
13{
14String strSQL = "INSERT INTO Categories (CategoryName, Description) VALUES (?, ?)";
15
16OleDbCommand dbComm = new OleDbCommand(strSQL, objConnection);
17dbComm.Parameters.Add("CategoryName", OleDbType.VarChar, 32, "CategoryName");
18dbComm.Parameters.Add("Description", OleDbType.VarChar, 128, "Description");
19
20dbComm.Parameters["CategoryName"].Value = txtCategoryName.Text;
21dbComm.Parameters["Description"].Value = txtDescription.Text;
22
23try
24{
25objConnection.Open();
26dbComm.ExecuteNonQuery();
27}
28catch (Exception ex)
29{
30Response.Write(ex.Message);
31Response.End();
32}
33finally
34{
35if (objConnection.State == ConnectionState.Open);
36objConnection.Close();
37}
38
39Response.Write("A new record has been added");
40Response.End();
41}
42}
43</script>