Below is the full source code. It contains the HTML and VB.net code that makes up our page. It's important to note that the VB.Net code is placed within the page_load event. This just means that every time the page is requested the page_load event is raised or run and the code we've written is executed.
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data.Oledb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Dim Connection As OledbConnection
Connection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;" & _
"Data Source=C:\Inetpub\wwwroot\code\Customers.mdb")
Connection.Open()
Dim Command As OleDbCommand
Command = New OleDbCommand("INSERT INTO tblCustomers(FirstName, LastName)" & _
"
VALUES ('Michael', 'Wall')", Connection)
Command.ExecuteNonQuery()
Connection.Close()
Label1.Text="Record Inserted"
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Insert Record into MS Access Database</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:label ID=label1 runat="server" />
</div>
</form>
</body>
</html>
<< Inserting Records with ASP.NET Part 2 |
Get the best asp web hosting provider now and save 30%
Plug and play ASP membership script that integrates with PayPal to let you charge recurring membership fees.
