Lesson 06: Adding Parameters to Commands

This lesson shows you how to use parameters in your commands.2 Here are the objectives of this lesson: Understand what a parameter is. Be informed about the benefits of using parameters. Learn how to create a parameter. Learn how to assign parameters to commands. Introduction When working with data, you’ll often want to filter results … Continue reading “Lesson 06: Adding Parameters to Commands”

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”