Connecting to a Microsoft Access database with ASP.NET - Manipulating a Microsoft Access database directly using ASP.NET
(Page 3 of 6 )
Once you complete everything as suggested in the previous section, you need to work with one more button, “Add,” within the same application. Add the following code to the “Add” button available.
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e
As System.EventArgs) Handles btnAdd.Click
Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\AccessDB\MyDB.mdb;User Id=admin;Password=;")
Dim cmd As New OleDbCommand
With cmd
.CommandText = "insert into emp (empno,ename,sal,deptno) values (" & Me.txtEmpno.Text & ",'" &
Me.txtEname.Text & "'," & Me.txtSal.Text & "," &
Me.txtDeptno.Text & ")"
.Connection = cn
.Connection.Open()
.ExecuteNonQuery()
.Connection.Close()
.Dispose()
End With
cn.Dispose()
'refresh the list
btnList_Click(Nothing, Nothing)
End Sub
Once you complete the above, you execute your application (by pressing F5), provide some reasonable values in the textboxes and finally click on the button “Add.” If you are lucky, you should be able to see the newly added row in the grid.
Not everybody will be lucky. Some of you may receive an error, “Operation must use an updateable query.” That single statement (or error) has several meanings, according to Microsoft. If you really want to know about the error, you simply copy and paste the error message into the “search” box of the Microsoft website and you will see plenty of explanations focusing on that error.
To solve that error in this scenario, you need to change your “web.config” file by providing the necessary “impersonation” configuration. Open the “web.config” file of your web application and insert the following line just below the “<system.web>” tag:
<identity impersonate="true"
userName="computername\administrator" password="password" />
Replace the “computername” with your system name and “password” with the password of the “administrator” account. You can also replace “administrator” with any other customized user account with respective privileges. I simply demonstrated this using the “administrator” user account.
Now, you should be able to run without any errors (hopefully).
Next: Connecting to a Microsoft Access database through ODBC using ASP.NET >>
More Microsoft Access Articles
More By Jagadish Chaterjee
/ 50 
