MISSION

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.....

Read more   

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 ...

Read 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)...

Read more   

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. ...

Read more   
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
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

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

Admission

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 :
Programming


The Instructor: