adonet - CIS 338 ADO.NET Coding Dr Ralph D Westfall...

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

View Full Document Right Arrow Icon
CIS 338: ADO.NET Coding Dr. Ralph D. Westfall February, 2007
Background image of page 1

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

View Full DocumentRight Arrow Icon
ADO.NET ADO stands for ActiveX Data Objects part of Microsoft's OLEDB strategy to enable programs to almost any kind of data on a computer provides objects to easily connect to a variety of data sources databases, mail servers, http servers, Excel documents, etc.
Background image of page 2
OLEDB Data Providers SQL client for SQLServer OleDbClient for other data sources, including Microsoft Access data provider objects include: Connection: to a specific file or server Command: holds/runs SQL/other text to query/update data, call stored procedures DataReader: high-speed, limited function
Background image of page 3

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

View Full DocumentRight Arrow Icon
OleDb Declarations Dim objCon As OleDbConnection Dim strCon As String (provider, path, etc.) Dim objCmd As OleDbCommand Dim strSQL As String associates SQL with connection Dim objRead As OleDbDataReader pulls data out of database Dim objDS as DataSet (holds data)
Background image of page 4
Data Adapter Object another data provider object uses SQL objects to transfer data back and forth between the application and the database VB.NET creates specific objects (code) for select, insert, update and delete OleDbSelectCommand1, OleDbDeleteCommand1, etc.
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 (scroll down) is not connected to database
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.

This note was uploaded on 04/13/2009 for the course CIS 338 taught by Professor Westfall during the Winter '09 term at Cal Poly Pomona.

Page1 / 19

adonet - CIS 338 ADO.NET Coding Dr Ralph D Westfall...

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