1 / 15

Putting VB & SQL To work

Putting VB & SQL To work. Stefano Grazioli. Debriefing. Easy meter. Accessing Enterprise Data. Using Excel & ADO. Where is my Data? . In memory DATASET. Database file on a DBMS. In a file. slow. slow. fast. Your local machine. Server. ADO. ActiveX Data Object

shadi
Download Presentation

Putting VB & SQL To work

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