Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk Computer Training Courses and Tutorials: MCSE Training, A+ Training, MS Office Training from www.cvision.co.uk
* call us on 0121 248 2400
To receive updates and new
releases, subscribe today
*
* HOME * CONTACT US
* ABOUT US * HOW TO ORDER * PURCHASE ORDERS * RESELLERS * ARTICLE * VIEW BASKET
*
Featured Courses
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*
View Complete List...
*

ADO.NET by VTC

By VTC
ADO.NET by VTC
Single CD £79.00 + VAT
Buy Now
Multi User Network CD £325.00 + VAT
Buy Now
 

 

More on Single User & Multi User Networkable CDs


Author - Mark Long
Duration - 5 Hours

COURSE INTRODUCTION

ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET cleanly factors data access from data manipulation into discrete components that can be used separately, or in tandem. ADO.NET includes .NET Framework data providers for connecting to a database, executing commands, and retrieving results. Those results can be presented to the database users in any number of ways. In this tutorial, Mark Long shows you, step by step, how to take advantage of ADO.NET’s functionality to enhance your network’s productivity.

COURSE OUTLINE

Course Introduction
  Welcome  (04:35)
  Course Overview  (05:28)
  ADO.NET in Action-DataReader  (06:33)
  ADO.NET in Action-DataSet  (05:16)
Overview of ADO.NET
  ADO.NET Objectives  (03:48)
  .NET Data Providers  (03:50)
  Using Data Namespaces  (06:27)
ADO.NET Objects
  ADO.NET Object Model  (04:04)
  Objects/Methods/Properties  (02:26)
Connecting To A Database
  Opening A Database Connection (03:13)
  Using Error Handling (04:55)
  Connection Status (04:02)
  Using Trusted Security (04:55)
  Connection String Variables (04:16)
  Connecting to Access (04:12)
  Using UDL Files (05:04)
  Provider Gotchas (03:02)
  Connection Miscellaneous (06:08)
Executing Commands
  SQLCommand Object (04:45)
  OleDbCommand Object (05:25)
  Single Value Queries (03:57)
  Parameterized Queries pt. 1 (04:23)
  Parameterized Queries pt. 2 (03:19)
Using Stored Procedures
  What is a Stored Procedure? (03:44)
  Creating Stored Procedures (04:38)
  Calling Stored Procedures (04:04)
  Creating Stored Procedures with Parameters (03:53)
  Passing Parameters to Stored Processes (04:21)
  Transactions pt. 1 (04:14)
  Transactions pt. 2 (03:25)
DataReader
  DataReader Basics (01:34)
  Using a DataReader (04:35)
  Multiple Result Sets in a DataReader (06:50)
  Reading Schema from a DataReader (04:32)
DataAdapter
  DataAdapter Basics (01:36)
  Using the DataAdapter (06:00)
  Inserting Data with CommandBuilder pt. 1 (05:19)
  Inserting Data with CommandBuilder pt. 2 (03:06)
  Updating Data with CommandBuilder (04:59)
  Deleting Data with CommandBuilder (06:05)
DataSet
  DataSet Basics (01:55)
  Typed DataSets (07:28)
  Creating a DataSet (02:43)
  DataTables (05:31)
  DataRows (04:09)
  DataColumns (05:19)
  DataViews (04:42)
Data Binding
  What is Data Binding? (02:59)
  Data Bound Textboxes (04:49)
  Life without Cursors (02:39)
  Navigating with Binding Objects pt. 1 (04:10)
  Navigating with Binding Objects pt. 2 (05:31)
  Navigating with Collections pt. 1 (05:20)
  Navigating with Collections pt. 2 (03:32)
  Complex Binding (07:08)
XML & ADO.NET
  XML Basics (05:21)
  XML Terminology (05:39)
  XML and .NET (03:15)
  Reading XML Data (04:10)
  Putting XML in DataSets (03:07)
  Writing XML from a DataSet (04:26)
  Much More XML (01:33)
What About ADO?
  Using ADO (03:05)
DataForm Wizard
  DataForm Wizard Basics (07:00)
  Best Use for DataForm Wizard (03:54)
Background Info
  Data Access TLA's (03:54)
Credits
  About the Author (01:22)
 
Printer friendly version   
Top of page
*
*
A-Z COURSE LIST  PROVIDERS CONTACT US  SITEMAP 
*

Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

CareerVision
61 CarolineStreet, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk


red arrow Website design by Aimpro UK red arrow Terms