O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Refreshing a Row After Submitting an Update

In Chapter 10, you learned how to construct and use INSERT, UPDATE, and DELETE queries to submit changes to your database. These queries are basically one-way streets. The database modifies the contents of the row based on the information you supply in the query. Although the database reports how many rows the query affected, it does not return the new contents of the modified rows.

Sometimes submitting an update to your database needs to be a two-way street. In Chapter 10, we discussed using the Microsoft SQL Server timestamp data type to ensure that you don’t unintentionally overwrite another user’s changes to the database. When the contents of the row change, the database generates a new value for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required