I have made a SQL table within Visual Basic 2012. I then made my dataset for inserting data. I made a form and linked it to the table adapter and when the program is running it allows the data to be added to the table but when I reopen the application that data is not there. I have tried two acceptchanges but they don't work. So it is not saving it the data that is in the "temporary table".
Me.TableTableAdapter1.InsertQuery(TextBox1.Text, TextBox2.Text, Dropdownseats.Text, dropdriver.Text)
BusesDataSet1.Table.AcceptChanges()
BusesDataSet1.AcceptChanges()
Does anyone one know why this is happening?????
*Changed the database to MS Access and I am still having problems. *