supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....


learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...


Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...


Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12

  • Category: Adobe
    Date: 2012-11-12

  • Category: Adobe
    Date: 2012-11-12

  • Category: Entercaps Traning Center
    Date: 2012-11-11
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
  • Pro .NET Best Practices
    Pro .NET Best Practices
  • Hardening Cisco Routers
    Hardening Cisco Routers
   ADO.NET 2.0 Core


This course is essential for trainees aspiring to build database applications.

ADO.NET 2.0 Core
Exam # Duration Language Level Type Classroom Code Fees
-- 15 English Core Course Classroom Cs124 0 LE
Description :

This course provide a comprehensive introduction to ADO.NET 2.0. It is intended to qualify trainees to build desktop database application using Visual Basic 2005. However, the information and skills acquired in this course could be easily utilized to create other types of applications that connect to a database or other data sources.

Objectives :
  • Describe ADO.Net Architecture and Object Model
  • Connect to SQL and other data sources
  • Perform connected database operations
  • Perform disconnected database operations
  • Implement multiple DataView
  • Implement transactions

Topics :

Introduction to ADO.NET

  • What is ADO.NET?
  • ADO.NET and the .NET Framework
  • ADO.NET components
  • .NET Framework Data Providers
  • ADO.NET object model
  • Connected objects
  • Disconnected objects

Connecting to Data Sources

  • Specifying the data source
  • Specifying the server and the database
  • Choosing the database objects
  • Programmatic connection
  • Creating connection objects
  • Managing the connection
  • Establishing and testing the connection
  • Customizing connection strings

Retrieving Scalar Values and Result Sets

  • Instantiating the command object
  • Specifying the SQL statement
  • Executing the command
  • Retrieving a re
  • sult set
  • Specifying the SQL query command
  • Reading the result set

Working with DataSets

  • What is a DataSet?
  • DataSet object model
  • DataSet versus DataTables
  • DataColumns and DataRows
  • DataSets properties & constraints
  • Filling DataSets manually
  • Filling DataSets programmatically
  • Finding data in DataSets
  • Relational DataSets
  • Creating relations between DataTables

Working with DataAdapters

  • What is DataAdapter?
  • DataAdapter structure
  • Filling DataSets with fetched data
  • Updating data sources with DataSets

Working with DataViews

  • What is DataView?
  • Creating a DataView
  • Manipulating data through DataViews
  • Converting a DataView to a DataTable

DataSets & Data Sources Integration

  • Manipulating disconnected data
  • SqlCommandBuilder object
  • Sending disconnected data to applications

ADO.NET Transactions

  • ACID properties
  • Connected mode transactions
  • Disconnected mode transactions
  • Implementing transactions

Recommended Knowledge :

This course requires having basic skills using Microsoft Windows operating system (Version XP or any later version). It also requires reasonable understanding of object-oriented programming concepts, SQL Server 2005, .NET Framework 2.0 and Visual Basic 2005.

Recommended Course(s) :

Visual Basic 2005 Core

Windows XP Core

Training Materials :

Official Courseware

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

This course is an essential part of EnterCaps Professional Diploma in Programming

Category :

The Instructor: