|
Provided by: Serebra Learning Corporation Visual Basic 6 0 Database Access Part IIMicrosoft Visual Basic (VB) |
 |
This course provides a detailed look at the ActiveX Data Object (ADO)that acts as the bridge between your application and a database. Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.
|
|
||||||||
Training
Provided by Serebra Learning Corporation
- V asked: How to get filtered records in Crystal reports or data reports on a table where I Want to filter records by name and date between two dates using dtpicker and dtpicker . Eg : I have table Named tab with fields ID, Name, Date of Joining. I have table in MS Access ACC.MDB and table name is tab I created a textbox and two dtpicker controls on a form. Suppose user wants to search for name starting with R and DOJ between // and //. Please give me the correct coding.
Visual Basic 6 0 Database Access Part II
AudienceObjectivesCreate and destroy connections to data sources and respond to events associated with the Connection object Create commands that build queries or access queries, tables, or stored procedures in a database Create recordsets and use them to view retrieved data Use the ADO Error collection to trap and handle errors Sort and filter records Search records using ADO navigation methods Insert, delete, and update record data Connect to a secured database system and understand how to protect the data within from corruption, once connected Choose suitable cursors for recordsets that balance application performance with features Execute stored procedures on a database system through the ADO command object
Designed for intermediate to advanced Visual Basic application programmers Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential.
TopicsProgramming with Active X Data Objects
- The ADO Object Model
- The Connection Object
- The Command Object
- The Recordset Object
- ADO Errors
Updating and Editing Data Records with ADO
- ADO Properties and Methods
- Modifying Data Records
- Disconnected Recordsets
Advanced Data Access with ADO
- Working with SQL Server Security
- Using ADO Cursors
- Maintaining Data Integrity Through ADO
- Running Stored Procedures with ADO
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
