ADO.NET is also a part of the .NET Framework. ADO.NET is used to handle data access. With ADO.NET
you can work with databases.
We are going to use the Northwind database in our examples.
First, import the "System.Data.OleDb" namespace. We need this namespace to work with
Microsoft Access and other OLE DB database providers. We will create the connection to the
database in the Page_Load subroutine. We create a dbconn variable as a new OleDbConnection class
with a connection string which identifies the OLE DB provider and the location of the database.
Then we open the database connection:
Note: The connection string must be a continuous string without a line break
To specify the records to retrieve from the database, we will create a dbcomm variable as a new
OleDbCommand class. The OleDbCommand class is for issuing SQL queries against database
The OleDbDataReader class is used to read a stream of records from a data source. A DataReader is
created by calling the ExecuteReader method of the OleDbCommand object:
Then we bind the DataReader to a Repeater control:
Always close both the DataReader and database connection after access to the database is no
Your Query was successfully sent!