Transcript Document

Financial Information Management
Putting VB & SQL
To Work
Stefano Grazioli
Critical Thinking
 Still going strong
 VPN, then “cmd”, then
runas /user:mcintire\MyUserName "C:\Program Files
(x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe"
 Easy meter
Financial Information Management
Accessing
Enterprise Data
Using Excel & ADO
Where is my Data?
In a
file
slow
fast
In
memory
DATASET
slow
In a DBMS
on the
network
Speed
slow
best
fast
Depends on bandwidth
Volume
medium
Small/medium
medium
Very large
Access
easy
easy
difficult
medium
Backup
medium
poor
n/a
excellent
Security
poor
Poor/medium
excellent
good
Your local machine
Server
ADO.NET
 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.
Database Plumbing
• Standard parts,
put together in standard
ways are called
architectures
• Standard parts are called
‘objects’
Software Objects
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 keyword new
Dim myDeskClock As DeskClock = new DeskClock()
Name, a variable
Class name (type) keyword
Method that
creates the deskclock
ADO architecture
Client (your program on your machine)
SqlConnection
Connection
string
SqlCommand
SqlAdapter
SQL Query
string
DataSet
DataTables
DataRows
On your
Spreadsheet
ListObject
DB Server
Remote
DataBase
(financial
data)
Financial Information Management
DEMO
Financial Information Management
WINIT
What Is New
In Technology?
You do the talking





Name, Major
Learning objectives
Things you like about the class
Things that can be improved
Attitude towards the Tournament
Financial Information Management
Homework
Using ADO to Retrieve Financial Data
 Make sure that you
understand the ADO
architecture diagram
before coding.