IT trainings > Technical

ADO.NET

ADO.NET

Goals

Be able to create Web database oriented applications.

Requirements

Have a good knowledge of Databases (tables, queries …), and basic skills of the SQL language (Select, Update, Insert, Delete), good knowledge of VB.Net or C#.

The database used for the training is SQL Server/MSDE or Access.

Contents

General Architecture of ADO. Net

  • ADO.Net Object Model
  • The different ‘Data Providers’ (OLEDB, SQL Server, ODBC, Oracle, …)
  • ‘Connected mode’ and ‘Disconnected Mode'
  • Objects available in ‘Connected’ mode (Connection, Command, …)
  • Objects available in ‘Disconnected’ mode (DataSet, DataView, …)
  • The DataForm Wizard

Connection and Command objects

  • Using the ‘Connection’ object (by code and by the ‘Server Explorer' of Visual Studio.Net)
  • Using the ‘Command’ and ‘DataReader’ objects:
    - Specifying the source of the ‘Command’, SQL expression or Stored Procedure
    - The different ‘Command’ types : ‘Select’ for reading the data ; ‘Update’, ‘Delete’, ‘Insert’ for updating the data; Stored Procedure
    - Using parameters (Input/Output/Return value)
    - Running a ‘Command’ by using a ‘DataReader’

DataAdapter, DataSet, DataTable & DataView

  • What are DataSet and DataTable?
  • What is a DataAdapter?
  • Setting up a DataAdapter, using ‘Command’ objects bound to the DataAdapter
  • Creating a strongly typed DataSet from a database structure, an XML file or manually
  • Populating a DataSet by using a DataAdapter
  • Updating the database by using a DataAdapter and a simple DataSet
  • Populating a DataSet from an XML file
  • Populating a DataSet from a Web Service returning data in XML format
  • Writing the content of a DataSet in an XML file
  • Sort, search and filter (using the DataView object)

Binding data in Windows Forms

  • Data Sources available for the binding
  • Data display in a Windows Form
  • Using data bound controls (DataGrid, Combobox, TextBox, etc…)
  • Navigation via the ‘CurrencyManager’ object

Updating the data on the database server

  • Database update process by using a DataAdapter and a DataSet
  • Catching and handling update errors (concurrent updates)
  • Updating linked tables
  • Using the ‘Transaction’ object

Practical info

3 Days   |   €  N/A   |  # ADONET

This training is only on request. Contact us for terms and conditions.


Download in pdf file
More information about this training?
All our courses are also available
intra-company

Training subsidies

Let’s stay in touch

We'll never share your email address and you can opt out at any time, we promise.