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 the System.Data.OleDb namespace for an Access database. This tutorial shows you the…

Updating Records: Disconnected Approach

We will currently take a glance at change records exploitation the disconnected approach. Like inserting and deleting records using the disconnected approach, updating records also use the DataAdapter, DataSet, and CommandBuilder classes to do…

Updating Records: Connected Approach

We will now take a look at updating the fields of records in a database table. Like inserting and deleting records, updating also uses the DbCommand.ExecuteNonQuery() method. The steps are pretty much…

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 new DataRow object, you will delete it from the DataTable of the DataSet. The following…

Deleting Records: Connected Approach

We will now delete a database record using the connected approach. The steps are the same as inserting a record while connected to a database which uses the DbCommand.ExecuteNonQuery() method. Create a Connection…

Inserting Records: Disconnected Approach

Inserting records utilizing the disengaged methodology is a little unique contrasted with doing it utilizing the associated methodology. We have to utilize the DataAdapter and the DataSet classes.When modifying records using the disconnected approach,…

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 and the DataSet class. The DataAdapter executes commands to the database and fills the…

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 you can work with the contents of the database while…

DataAdapter Class

A DataAdapter can be considered as a bridge between the actual data source to your application. It is commonly used together with a DataSet. Using DataAdapter and DataSet is the disconnected way of retrieving data from the…