ADO.NET and Databases

Databases and ADO.NET

Most of the applications today uses some sort of data storage. Perhaps the only applications I can imagine that doesn't ...
Read More

SQL Basics

Before you deal with accessing and modifying databases, you first need to know the basics of SQL (Structured Query Language) ...
Read More

Installing SQL Server 2008 Express

We will be using Microsoft SQL Server 2008 Express as our main data source. SQL Server is already installed if ...
Read More

Creating a Sample Database and Table

We will create a database containing a table with several records that we will use in the following lessons. This ...
Read More

Connecting to a Database with Visual Studio Tools

Before we delve into the data-driven world of ADO.NET, let's first take a look at some tools available in the ...
Read More

Connection Strings

A connection string may be a series of name/value pairs separated by punctuation that indicate the settings for connecting to ...
Read More

Data Providers

A data provider is a set of classes the manages and handles the connection to a data source such as ...
Read More

Connection Class

Each data provider in ADO.NET contains a Connection class that inherits from the System.Data.Common.DbConnection  class. The DbConnection serves as the base class for all the Connection classes ...
Read More

Command Class

Each data provider has their Command class which is used to execute SQL commands or stored procedures to the database. Each Command ...
Read More

DataReader Class

A DataReader object allows forward-only, read-only access to a database. Different properties and strategies for the Command classes are saved for later exercises. Each ...
Read More

DataAdapter Class

A DataAdapter can be considered as a bridge between the actual data source to your application. It is commonly used together with ...
Read More

DataSet Class

The System.Data.DataSet class holds data that are retrieved from the database. The DataSet class allows you to hold disconnected data. It means ...
Read More

Connecting to a Database Through Code

The first example we encountered for connecting to databases involves Visual Studio tools that don't require you to type any ...
Read More

Querying a Database: Connected Approach

Querying is the process of retrieving data from a data source such as a database. We can do queries using the ...
Read More

Querying a Database: Disconnected Approach

We can query results from a database while not keeping associate degree open connection.This is through the assistance of the DataAdapter classes ...
Read More

Inserting Records: Connected Approach

Inserting records is very easy to do using the ADO.NET's Command classes. We will discuss inserting of records using the ...
Read More

Inserting Records: Disconnected Approach

Inserting records utilizing the disengaged methodology is a little unique contrasted with doing it utilizing the associated methodology. We have ...
Read More

Deleting Records: Connected Approach

We will now delete a database record using the connected approach. The steps are the same as inserting a record ...
Read More

Deleting Records: Disconnected Approach

Deleting database using the disconnected approach is similar to inserting a row using the DataSet and the DataAdapter classes. But instead of adding a ...
Read More

Updating Records: Connected Approach

We will now take a look at updating the fields of records in a database table. Like inserting and deleting ...
Read More

Updating Records: Disconnected Approach

We will currently take a glance at change records exploitation the disconnected approach. Like inserting and deleting records using the ...
Read More

Simple Student Enrollment System – Connected Approach

We will create a Simple Enrollment System that allows you to search for a student in the database using a ...
Read More

Simple Student Enrollment System

We will create a Simple Enrollment System that allows you to search for a student in the database using a ...
Read More

Connecting to an Access Database

You can use the classes in ADO.NET to connect to a Microsoft Access Database. We use the OLE DB data provider and ...
Read More

Querying Data From an Access Database

In this lesson, we create a simple form that queries and shows data of individual record from the Access database ...
Read More