This seems to have done somthing but not update the table, it does not crash anymore but it does not update the table either and i cant figure out why? any suggestions my code now is>
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
DataSet31.Clear()
OleDbDataAdapter1.Fill(DataSet31)
DataGrid1.DataSource = DataSet31
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
OleDbDataAdapter1.Update(DataSet31)
MessageBox.Show("Datbase Updated")
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
SqlDataAdapter1.Fill(DataSet11)
DataGrid2.DataSource = (DataSet11)
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim objcommandbuilder As New SqlClient.SqlCommandBuilder
OleDbDataAdapter1.Update(DataSet31, "jobs")
MessageBox.Show("database Updated")
End Sub