Thx for the prompt reply. CommandExecute.aspx is the code I'm using to try and update the Employees table in Northwind.mdb. I've got the code and database on a webserver.
Thx,
Michael
<%@ Page Language="
VB" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
Sub btnRun_Click(sender As Object, e As EventArgs)
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=\\kgbrenna-desk\mtyoung\data\wind.mdb"
Dim dbConnection As New OleDbConnection(connectionString)
dbConnection.Open()
Dim commandString As String = "INSERT INTO Employees(FirstName, LastName) " & _
"Values(@FirstName, @LastName)"
Dim dbCommand As New OleDbCommand(commandString, dbConnection)
Dim firstNameParam As New OleDbParameter("@FirstName", OleDbType.VarChar, 10)
firstNameParam.Value = txtFirstName.Text
dbCommand.Parameters.Add(firstNameParam)
Dim lastNameParam As New OleDbParameter("@LastName", OleDbType.VarChar, 20)
LastNameParam.Value = txtLastName.Text
dbCommand.Parameters.Add(LastNameParam)
dbCommand.ExecuteNonQuery()
dbConnection.Close()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<asp:Label id="Label1" runat="server">First Name</asp:Label>
<asp:TextBox id="txtFirstName" runat="server"></asp:TextBox>
</p>
<p>
<asp:Label id="Label2" runat="server">Last Name</asp:Label>
<asp:TextBox id="txtLastName" runat="server"></asp:TextBox>
</p>
<p>
<asp:Button id="btnRun" onclick="btnRun_Click" runat="server" Text="Run"></asp:Button>
</p>
</form>
</body>
</html>
Updating Database
