financial information management putting vb & sql to work stefano grazioli
TRANSCRIPT
![Page 1: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/1.jpg)
Fin
anci
al In
form
ati
on
M
an
ag
em
en
t
Putting VB & SQLTo Work
Stefano Grazioli
![Page 2: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/2.jpg)
Critical Thinking Still going strong VPN, then “cmd”, thenrunas /user:mcintire\MyUserName "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe"
Easy meter
![Page 3: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/3.jpg)
Fin
anci
al In
form
ati
on
M
an
ag
em
en
t
AccessingEnterprise Data
Using Excel & ADO
![Page 4: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/4.jpg)
Where is my Data?
In a DBMS on the
network
In memoryDATASET
fast
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
In a file
slow
Your local machine Server
slow
![Page 5: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/5.jpg)
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.
![Page 6: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/6.jpg)
Database Plumbing• Standard parts,
put together in standard ways are called architectures
• Standard parts are called ‘objects’
![Page 7: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/7.jpg)
Software Objects
![Page 8: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/8.jpg)
Software Objects An object is a bundle of data and ‘methods’ Object Classes and Object Instances
Class = code to build an instanceInstance = 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
![Page 9: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/9.jpg)
ADO architecture
RemoteDataBase(financial
data)
Client (your program on your machine)
SQL Querystring
Connectionstring
SqlConnection
SqlAdapter
ListObject
DataSetDataTables
DataRows
DB Server
SqlCommand
On yourSpreadsheet
![Page 10: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/10.jpg)
Fin
anci
al In
form
ati
on
M
an
ag
em
en
t
DEMO
![Page 11: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/11.jpg)
Fin
anci
al In
form
ati
on
M
an
ag
em
en
t WINITWhat Is New
In Technology?
![Page 12: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/12.jpg)
You do the talking Name, Major Learning objectives Things you like about the class Things that can be improved Attitude towards the Tournament
![Page 13: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/13.jpg)
Fin
anci
al In
form
ati
on
M
an
ag
em
en
t HomeworkUsing ADO to Retrieve Financial Data
![Page 14: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/14.jpg)
SUGGESTIONS
Make sure that you understand the ADO architecture diagram before coding.
![Page 15: Financial Information Management Putting VB & SQL To Work Stefano Grazioli](https://reader031.vdocuments.us/reader031/viewer/2022032206/56649ef55503460f94c08bd7/html5/thumbnails/15.jpg)