Problem in saving back to Access database connected to VB.NET application.?

Question

Hi everyone,
Does anyone know what is the problem in the following code? OleDbDataAdapter cannot update the datasource, and I cannot understand what the problem is.

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim a As Integer
OleDbConnection1.Open()
DataSet11.tbl_master.Addtbl_masterRow(TextBox1.Text, TextBox2.Text, TextBox3.Text)


DataSet11.GetChanges()
a = OleDbDataAdapter1.Update(DataSet11)
DataSet11.AcceptChanges()
OleDbConnection1.Close()

End Sub


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OleDbDataAdapter1.Fill(DataSet11)
End Sub

Any help uppreciated

Answer 1

I'm not certain on this, but I believe your dataset is just a copy of your database from which you can manipulate and display data without messing up the original. So when you update the dataset, you're only updating the copy. Make sure you have a function that is writing updates to the database itself.

hope that helps.

Answer 2

Is the different device working the same or later utility? if not it could not comprehend the 2000/ get admission to documents. Are you beneficial you're copying the completed database. and how vast is the flash rigidity? If the information is larger than the rigidity it is going to drop documents as quickly because it incredibly is finished. better if the machines are in the same community to repeat the information around the community employing shared folders. you will desire thehole mdb record.