Lesson 05: Working with Disconnected Data – The DataSet and SqlDataAdapter

This lesson explains how to work with disconnected data, using the DataSet and SqlDataAdapter objects. Here are the objectives of this lesson: Understand the need for disconnected data. Obtain a basic understanding of what a DataSet is for. Learn to use a SqlDataAdapter to retrieve and update data. Introduction In Lesson 3, we discussed a … Continue reading “Lesson 05: Working with Disconnected Data – The DataSet and SqlDataAdapter”

Lesson 04: Reading Data with the SqlDataReader

This lesson explains how to read data with a SqlDataReader object. Here are the objectives of this lesson: Learn what a SqlDataReader is used for. Know how to read data using a SqlDataReader. Understand the need to close a SqlDataReader. Introduction A SqlDataReader is a type that is good for reading data in the most … Continue reading “Lesson 04: Reading Data with the SqlDataReader”

Lesson 02: The SqlConnection Object

This lesson describes the SqlConnection object and how to connect to a data base. Here are the objectives of this lesson: Know what connection objects are used for. Learn how to instantiate a SqlConnection object. Understand how the SqlConnection object is used in applications. Comprehend the importance of effective connection lifetime management. Introduction The first … Continue reading “Lesson 02: The SqlConnection Object”

Lesson 01: Introduction to ADO.NET

This lesson is an introduction to ADO.NET.  It introduces primary ADO.NET concepts and objects that you will learn about in later lessons.  Here are the objectives of this lesson: Learn what ADO.NET is. Understand what a data provider is. Understand what a connection object is. Understand what a command object is. Understand what a DataReader … Continue reading “Lesson 01: Introduction to ADO.NET”