1 / 15

Leveraging ADO and SQL: Accessing Enterprise Data with Excel and Understanding Object-Oriented Concepts

This debriefing explores the powerful combination of ADO and SQL to efficiently access enterprise data using Excel. Learn how to run SQL queries on remote servers, collect results, and present them effectively. We discuss core concepts of database architecture, emphasizing the importance of standards and object-oriented programming in software development. Get hands-on insights on using ADO to retrieve financial data, supported by practical examples and best practices for coding with ADO and understanding its architecture.

shadi
Télécharger la présentation

Leveraging ADO and SQL: Accessing Enterprise Data with Excel and Understanding Object-Oriented Concepts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Putting VB & SQLTo work Stefano Grazioli

  2. Debriefing • Easy meter

  3. AccessingEnterprise Data Using Excel & ADO

  4. Where is my Data? In memoryDATASET Databasefile on a DBMS In a file slow slow fast Your local machine Server

  5. ADO • ActiveX Data Object • MS Technology to manage enterprise data • Use ADO to run SQL queries on remote servers, collect the results, and present them to the user.

  6. Database Plumbing • Standard parts,put together in standard ways are called architectures

  7. Software Objects

  8. Software Objects • An object is a bundle of data and ‘methods’ • Object Classes and Object Instances Class = code to build an instance Instance = physical item running on your machine • Instances are built with the keywordnew Dim myDeskClock As DeskClock = new DeskClock() Name, a variable Class name (type) keyword Method that creates the deskclock

  9. ADO architecture Client (your program on your machine) DB Server SqlConnection Connectionstring RemoteDataBase (financial data) SqlCommand SqlAdapter SQL Querystring DataSetDataTablesDataRows On yourSpreadsheet ListObject

  10. DEMO

  11. WINIT What Is NewIn Technology?

  12. You do the talking • Name, Major • Learning objectives • Things you like about the class • Things that can be improved • Attitude towards the Tournament

  13. Homework Using ADO to Retrieve Financial Data

  14. Suggestions • Make sure that you understand the ADO architecture diagram before coding.

More Related