Be able to create Web database oriented applications.
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.
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
Download in pdf file
More information about this training?
Let’s stay in touch
We'll never share your email address and you can opt out at any time, we promise.