person icon SUPRIO DUTTA



updated on icon Updated on Sep, 2023

language icon Language - English

person icon SUPRIO DUTTA

architecture icon SQL,Development,Web Development,.Net


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

ADODotNET is a set of classes (a framework) to interact with data sources such as databases and XML files.  ADO is the acronym for ActiveX Data Objects. It allows us to connect to underlying data or databases. It has classes and methods to retrieve and manipulate data.

The following are a few of the dot NET applications that use ADODotNET to connect to a database, execute commands and retrieve data from the database.

  • ASP.NET Web Applications

  • Console Applications

  • Windows Applications.

Various Connection Architectures

There are the following two types of connection architectures:

  1. Connected architecture: the application remains connected with the database throughout the processing.

  2. Disconnected architecture: the application automatically connects/disconnects during the processing. The application uses temporary data on the application side called a DataSet

Important Classes in ADODotNET

We can also observe various classes in the preceding diagram. They are:

  1. Connection Class

  2. Command Class

  3. DataReader Class

  4. DataAdaptor Class

  5. DataSet Class

1. Connection Class

In ADODotNET, we use these connection classes to connect to the database. These connection classes also manage transactions and connection pooling. To learn more about connection classes, start here: Connection in ADODotNET.

2. Command Class

The Command class provides methods for storing and executing SQL statements and Stored Procedures. The following are the various commands that are executed by the Command Class.

  • ExecuteReader: Returns data to the client as rows. This would typically be an SQL select statement or a Stored Procedure that contains one or more select statements. This method returns a DataReader object that can be used to fill a DataTable object or used directly for printing reports and so forth.

  • ExecuteNonQuery: Executes a command that changes the data in the database, such as an update, delete, or insert statement, or a Stored Procedure that contains one or more of these statements. This method returns an integer that is the number of rows affected by the query.

  • ExecuteScalar: This method only returns a single value. This kind of query returns a count of rows or a calculated value.

  • ExecuteXMLReader: (SqlClient classes only) Obtains data from an SQL Server 2000 database using an XML stream. Returns an XML Reader object.

3. DataReader Class

The DataReader is used to retrieve data. It is used in conjunction with the Command class to execute an SQL Select statement and then access the returned rows. Learn more here: Data Reader in C#.

4. DataAdapter Class

The DataAdapter is used to connect DataSets to databases. The DataAdapter is most useful when using data-bound controls in Windows Forms, but it can also be used to provide an easy way to manage the connection between your application and the underlying database tables, views and Stored Procedures. Learn more here: Data Adapter in ADODotNET

5. DataSet Class

The DataSet is the heart of ADODotNET . The DataSet is essentially a collection of DataTable objects. In turn each object contains a collection of DataColumn and DataRow objects. The DataSet also contains a Relations collection that can be used to define relations among Data Table Objects.


What will you learn in this course:

  • ddl,dml basics
  • Working with stored Procedures in code behind,working with management studio
  • working with Stored procedure in management studio
  • CRUD PROJECTS AND Search Based Project


What are the prerequisites for this course?

  • Prior knowledge in sql queries
  • HTML controls and AspDotNet control Basics.
  • prior knowledge in csharp progamming


Check out the detailed breakdown of what’s inside the course

SQL BASICS-Create Database,Table,Insert,Update,Delete Query
4 Lectures
  • play icon CREATE DATABASE ,TABLE-INSERT QUERY 06:14 06:14
  • play icon Update Query 08:14 08:14
  • play icon DELETE QUERY 04:40 04:40
  • play icon Auto-Increment Primary key 05:26 05:26
2 Lectures
Crud Operation Project
10 Lectures

Instructor Details




IT Professional with 8+ Experience in software training and more than 10+ years at undergraduate and graduate level mathematics. Mentoring Dotnet framework and its interrelated Corporate level Education .,Microsoft sql server, my sql oracle server,objected oriented programing langauge like c++ and Java... knowledge offered is with Advanced topics in the desktop applications and consumed projects are mainly comprising of Enterprise based applications,client relationship management and E-Commerce.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us