Description
This advanced training course focuses on database access (ADO), the creation of COM components and the creation of dynamic Web applications.
Who is this training for ?
For whom ?Visual Basic 6 Developers.
Prerequisites
Training objectives
Training program
- Access to databases
- Access providers: ODBC and OLE-DB.
- Data access objects: ADO.
- Data Environment, Data Control.
- Data Grid.
- ADO objects Object model.
- Connecting to a data source.
- Commands.
- Data recovery: the Recordset.
- Update, search, sort.
- Data integrity: transactions, locks.
- Execution of stored procedures.
- Practical work Using data access tools.
- Creating an input form.
- Retrieving data via a stored procedure.
- Managing a write transaction.
- Creating Com components
- Reusability, simplification, optimization.
- Standard interfaces, choice of component type.
- Creation of a client application.
- Object variables, instantiation and manipulation of objects.
- Class modules.
- Definitions of properties, methods, events.
- Triggering errors.
- COM and ADO: data-related components.
- Collections.
- Creating interfaces.
- Compiling and saving data components.
- Practical work Creation and testing of components: a COM Dll for banking services, one for connecting to a database with ADO.
- Example: Active X controls
- Creation.
- Properties, methods, events.
- Creating a data-dependent control.
- Creating a supplier control
- Practical work Creation of an Active X control for entering dates.
- Creation of an Active X data provider control with ADO.
- Client-server and multi-tier: Com
- Approach.
- Encapsulation of ADO objects.
- COM+ and MTS.
- Multi-object transaction: the "double commit" .
- Resource optimization.
- COM+ and security.
- Practical work Management of a "double commit" transaction.
- Visual Basic and Internet Development
- Server-side and client-side development.
- The WebBrowser control.
- Active X Documents.
- Visual Basic and Vbscript.
- DHTML.
- COM and ASP, COM and ADO.
- Practical work Creation of a browser on a Visual Basic form.
- Creating a Document Active X project running in IE.
- Getting ready for Visual Basic .NET
- The platform.
- NET, architecture.
- The VB.
- NET.
- Visual Studio.
- NET, TEEN.
- NET.
