M303

M303: Visual Basic for OLE/ActiveX, Database and Web Applications - 3 days

Who Should Attend:

Software engineers, system analysts, computer science managers, students and other IT professionals intending to adopt Visual Basic (VB) to create graphical applications in the Windows environment.

Prerequisites:

Participants are expected to be familiar with Windows 98/NT, and the fundamentals of Visual Basic language and graphical user interface (GUI) programming.

Objectives:

This hands-on module aims to train the participant to use advanced programming techniques in Visual Basic. Advanced programming concepts include DLL programming, advanced ActiveX programming, SQL integration and MS Office integration in Visual Basic. It covers the use of Visual Basics to create applications for OLE/ActiveX, database, and web applications. Essential VB concepts, including OLE and ActiveX custom controls, and database concepts including ADO, are also taught. At the end of this module, participants should be able to write complex VB graphical programs.

Contents:

Visual Basic IDE Review: Menu Bar; Toolbar Creating & Managing Projects; Setting Environment, Editor, and Project Options; Toolbox; Adding Controls to Forms; Adding Tools to the Toolbox; Properties Window; Changing Control Properties; Project/Code Window; Menu Editor.

Using OLE and ActiveX Control: Using OLE Automation to Integrate Applications; Creating OLE Servers; Out-of-Process versus In-Process Servers; Registering / Unregistering your Compiled

OLE Server. ActiveX Controls: Reusable components; Creating and using ActiveX controls.

Internet and DHTMK Applications: Developing DHTML Applications: What is a DHTML Application? Dynamic HTML in Visual Basic. Designing Pages for DHTML Applications: Using Existing Pages; Creating New Pages; Positioning and Grouping; Hyperlinks; Tables; Lists; Page Designer. Testing, Building, and Deployment DHTML Applications. IIS Applications: IIS Application Development Process; Webclass Events; Responding to Events in IIS Applications. State Management in IIS Applications.

Handling Data: Creating An Application with the Data Control; Data Control Properties; Binding Other Controls; RecordSet; Adding, Viewing, Locating, and Editing Records; Locating Specific Records; Data-Bound List Box, Data-Bound Combo Box, and Data-Bound Grid.

ADO, Database Designer and Data Environment Designer: Active Data Objects (ADO), Data-bound Controls, Data Validation and Data Formatting, DHTML and Data Access, Run-time Data Binding. Data View Window: Adding a Data Link, Opening a Table in Data View, Managing

Database Diagrams. Data Environment Designer: Referencing Data Environment Designer, Adding Data Environment Designer Object, Connection Objects, Setting Connection Name and Data Source, Setting Logon Information, Command Objects, Dragging from Data View to Data

Environment. Binding Data to Data Environment: Adding Data Bound Controls, Inserting ADO Data Control, Specifying ADO Properties Programmatically, DataList Control, DataGrid Control, DataCombo Control, Adding Relations. Writing Reports with Microsoft Data Report Designer: Creating, Exporting, and Printing a Report. Interaction of DHTML Application with SQL Server.

--------

Contact Us Today for enquiries on courses