How do I create an SQL query to save changes in my database?
Posted on 2007-11-23
I have a database table called table1 which I have loaded into a visual basic program. When I dragged the icon from the data sources window to the form and created the datagrid, a toolbar was created with a save button on. However, when I click it to save changes, the changes are not actually saved.
I navigated to the properties of my tableadapter and found that the updatecommand box was empty (so I assume the update command does nothing when called in a program).
What would I need to put in a new query to save changes to my database? It only has 2 columns: Episode and Rating.