Dataset not updating database vb net

After that I called the Data Adapter's Update method to save the changes to the database table.

The way the architecture works with the Data Adapter is that you can make any changes you want to the filled Data Set, and it won't affect the database until you call the Update method.

Add("Last Name", Get Type(String)) ' Build the Test Scores table.

Add("Student Id", Get Type(Integer)) dt_testscores.

When Update is called, the Data Adapter will attempt to execute each query (UPDATE, INSERT, DELETE) on every row of the Data Set that has been updated, inserted, and deleted.

For example, if you call Delete on a row on the Data Set, then when Update is called on the Data Adapter, the Delete Command of the Data Adapter will be called using the particular row in the Data Set.

Leave a Reply