by Janice Friedman | Jun 7, 2016 | Lessons
In the last lesson, you learned how to create a simple loop using the goto statement. I advised you that this is not the best way to perform loops in C#. The information in this lesson will teach you the proper way to execute iterative logic with the various C#...
by Janice Friedman | Jun 7, 2016 | Lessons
This lesson will get you started with C# by introducing a few very simple programs. Here are the objectives of this lesson: Understand the basic structure of a C# program. Obtain a basic familiarization of what a “Namespace” is. Obtain a basic...
by Janice Friedman | Jun 7, 2016 | Lessons
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...
by Janice Friedman | Jun 7, 2016 | Lessons
This lesson shows how to pass values into SQL Server commands with parameters. You will create a named placeholder, specify a parameter’s type and size, and add it to the command before executing a query. Keep user values separate from SQL command text.Match...
by Janice Friedman | Jun 7, 2016 | Lessons
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...
by Janice Friedman | Jun 7, 2016 | Lessons
A SqlDataReader lets you read a query result row by row. This lesson shows how to create it, advance through the result, handle database nulls, and close the reader and its connection. Obtain the reader from a command.Read each row and select the right typed...