Sending contents of multiple text box/combo box to Access database

[chrismid259]

Hi,
Currently I'm working on a project based upon ticket sales. I'm at a stage where I need to send data collected during the ticket booking process to the Access database that I have set up. I'm attempting to send information such as forename, surname, address etc to the database that I have set up. I've had a go at coding it but constantly get an "OleDbException was unhandled" error.

This is the code I've implemented so far. I've highlighted the code that shows as an error in red.

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click

Dim info As DataRow
info = Me.DatabaseDataSet1.customers.NewRow()

info.Item("forename") = Me.txtForename.Text
info.Item("surname") = Me.txtSurname.Text

Me.DatabaseDataSet1.customers.Rows.Add(info)
Me.CustomersTableAdapter.Update(Me.DatabaseDataSet1)

End Sub

Can anyone see what I'm doing wrong here?

 

[jmcilhinney]

What does the exception say you're doing wrong? Don't ignore the information the IDE is trying to give you.

 

[chrismid259]

What does the exception say you're doing wrong? Don't ignore the information the IDE is trying to give you.

"Your network access was interrupted. To continue, close the database, and then open it again."

For additional information I've used catch exception; http://oi56.tinypic.com/2dj1euu.jpg