Lesson 07: Using Stored Procedures

This lesson shows how to use stored procedures in your data access code. Here are the objectives of this lesson: Learn how to modify the SqlCommand object to use a stored procedure. Understand how to use parameters with stored procedures. Introduction A stored procedures is a pre-defined, reusable routine that is stored in a database. … Continue reading “Lesson 07: Using Stored Procedures”

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”