vbdbobjects - CIS 338 Drag and Drop Databases in Visual...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 338: Drag and Drop Databases in Visual Studio.NET Dr. Ralph D. Westfall November, 2008
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Universal Data Access ODBC = open database connectivity standard API for accessing relational databases API = application programming interface "drivers" for Access, dBase, DB2, Excel, text, etc. Microsoft is leading promoter of ODBC
Background image of page 2
Universal Data Access - 2 OLE-DB: DB object linking & embedding accesses relational databases through ODBC accesses other data also e-mail, video, voice, images, web pages, etc. data is accessed "in place" (don't have to load it into a database)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
OLE-DB Concepts data store = "persistent" collection of data data provider = gets data from store has OLE-DB database, email, etc. "drivers" data consumer = application using data (ActiveX Data Objects) ADO.NET
Background image of page 4
Data Provider Objects Connection: application to database, or to some other data source DataAdapter: like a bridge sending data back/forth between application and DB Command: i.e., holds SQL code, etc. DataReader: high performance, limited function object for getting
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DataSet Object more functionality than a DataReader holds a copy (cache) of data in memory NOT permanently connected to database, so changes do not immediately go back in can hold one or more DataTable objects hold records in a DataRow collection
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 22

vbdbobjects - CIS 338 Drag and Drop Databases in Visual...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online