Microsoft® Visual Basic® .NET 2003 Kick Start

Updating Data

You've pretty much mastered pulling data out of a database, you've used it for data binding and even worked with the data to get the desired result. The next big task is to send data back to the database. There are a few methods of doing this, either issuing your own individual SQL statements to update the database, or by setting up the DataAdapter and letting it handle all of the updates for you. When you use the DataAdapter's Update method, it handles executing the required SQL statements for each insert, delete, or modification in your DataTable(s). The DataAdapter method is usually what you will use with Windows Forms development, but executing SQL statements one at a time can also be useful, and is often used in Web applications. ...