Skip to content
Play overlay
Preview this course

ADO.net Programming

ADO.Net using ASP.net


Suprio Dutta

Summary

Price
Free
Study method
Online, On Demand What's this?
Duration
2.8 hours
Qualification
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

22 students purchased this course

Add to basket or enquire

Start course

Overview

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.

  1. Client server communication architecture-
  2. ASP.NET Web Applications
  3. Console Applications
  4. Windows Applications.
  5. Various Connection Architectures

Curriculum

5
sections
25
lectures
2h 48m
total

Course media

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.

Who is this course for?

Professionals who want to develop career in ASP.NET DEVELEOPEMNT

Requirements

BASICS OF SQL,BASICS OF ASP.NET 2.0

Career path

CAREER IN WEB DEVELOPMENT ASSOCIATED WITH MICROSOFT TECHNOLOGIIES.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.