how can I actually commit changes to the SQL database programtically?
Posted on 2008-02-01
I have VB 2008 Express Edition with MS SQL Server 2005 Express Edition. I have used the built-in wizards in the VB environment to build a database, connect it to the program and insert, change and delete records. It even saved the records. However, after I modified the program a little (didn't do anything to automatically generated code that saves the records to the database), it quit saving the changes. It will save them as long as I don't quit the application, but once I commit the applciation the changes I made are no longer there. Any suggestions?