Data update is not saved in VB.NET application

[Mindstorm]

I try to add/edit records in a DataGridView in VB.Net. The addition/modification performed at DGV, and also at the database. However, when I close the application and I recover, my additions/modifications are not saved, I found my old data.

Here is my code

 cmdInsert.CommandType = CommandType.Text
 cmdInsert.CommandText = "insert into File values('" & txtcod.Text & "','" & txtno.Text & "','" & txtfoct.Text & "', '" & Txtbas.Text & "' )"
cmdInsert.Connection() = myConnection 
cmdInsert.ExecuteNonQuery()
cnx.Close()
MessageBox.show("Listing added correctly")

[absolute55]

So stupid question, but:
- Is what the code is reached (in debug mode)
- If it is reached, is that the database is updated?

[Mindstorm]

Yes the code is reached. The database is updated too. The problem is that when I restart a second time running the application, I can not find my data inserted. The data are added after they are gone after a second run. In the load of the page that contains the DataGridView (DGV), I have a DataSet. Here is my code:

Try
            connect()
            sql = "select * from File"
            cmd.CommandText = sql
            cmd.Connection() = myConnection
            myDataAdapter.Fill(myDataSet, "File")
            myDataTable = myDataSet.Tables("File")
 
            MyDGV.DataSource = myDataTable

[$tatic]

A commit will be better:

 cmdInsert.CommandType = CommandType.Text
 cmdInsert.CommandText = "insert into File values('" & txtcod.Text & "','" & txtno.Text & "','" & txtfoct.Text & "', '" & Txtbas.Text & "' )"
cmdInsert.Connection() = maConnection 
cmdInsert.ExecuteNonQuery()
cmdInsert.Commit()
cnx.Close()
MessageBox.show("Listing added correctly")

[Mindstorm]

Thanks for you comment but commit is useless for me. I use no transactions and my database is not read only either. If I am correct commit is of no use if no transaction has been started.

What I have noticed is that all my changes are made in the database, but they are not saved. Indeed, everything is included if I relaunch the project. However, my code is the same used in another project and another database.

Then do you think this can be because of my Access used for database?