saving records to access 2007 database

[johnsheehan]

I am working on a project to create a front end in vb 2010 for an access database. It is adding the records in vb but not saving them in the database; this is the code i have so far:

Inline Code Example HerePublic Class Form2

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    AuthorsTblTableAdapter1.Insert(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, TextBox5.Text)
    Form1.Show()
    Form1.Enabled = True
    Form1.AuthorsTblTableAdapter.Update(Form1.BooksDataSet.authorsTbl)
    Me.Close()
End Sub
`
Where am i going wrong?

[oussama_1]

Read this

[johnsheehan]

Thanks, i will try it later on.

[johnsheehan]

ok, got this to work, but now i'm stuck on delete.

[oussama_1]

Dim cmd As New OleDbCommand
cmd.Connection = connection
cmd.CommandType = CommandType.Text
cmd.CommandText = "DELETE FROM Table WHERE ColumnName =" & String & ""
connection.Open()
cmd.ExecuteNonQuery()
connection.Close()