In this video we write A LOT of code to demonstrate how to use ADO.NET 2.0′s DataSet and DataAdapters to work in disconnected mode with a SQL Server Express Edition database. We define INSERT, UPDATE, DELETE and SELECT commands for our DataAdapters so that it can work with changes we made to our data while disconnected from the database. We talk about DataSets as in-memory representations of the tables and data in a database. Your application can both work with the data (as if it were connected directly to it) however also conserve resources with a shared database (including database connections and table locks on the data). We’re working our way towards discussing how the latest incarnation of ADO.NET uses techniques like these (an in-memory representation of data, working disconnected, etc.) to present data as strongly typed objects rather than as relational data.

« Previous Lesson — Visual C# 2010 Express Edition for Absolute Beginners — Next Lesson »

Watch a 1 Minute Preview of this Video

This is a short preview that demonstrates the quality of the screencasts we offer at LearnVisualStudio.NET.

Scroll down and click the play button in the lower-left hand corner of the video player to start watching.

The full length video is 27 Minutes, 42 Seconds and is available to LearnVisualStudio.NET members. Join today!