ADO.NET

Microsoft® ADO.NET : 

Microsoft® ADO.NET Presented by Joseph J. Sarna Jr. JJS Systems, LLC

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

ADO versus ADO.NET : 

ADO versus ADO.NET

ADO versus ADO.NET (continued) : 

ADO versus ADO.NET (continued)

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

ADO.NET Architecture Diagram : 

ADO.NET Architecture Diagram

ADO.NET Namespaces : 

ADO.NET Namespaces

Importing the ADO.NET Namespaces : 

Importing the ADO.NET Namespaces Needed to build a data access application For OLE DB: Imports System.Data Imports System.Data.OleDB For SQL Server: Imports System.Data Imports System.Data.SQLClient

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

Connection object : 

Connection object Connects to databases. Two provider-specific classes SqlConnection OleDbConnection. Connections can be opened in two ways: Explicitly by calling the Open method on the connection Implicitly when using a DataAdapter. Connections handle transactions

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

Command Object : 

Command Object Information submitted to a database as a query via a Connection object Two provider-specific classes SqlCommand OleDbCommand Input and output parameters are supported, along with return values as part of the command syntax Results are returned in the form of streams. Accessed by: DataReader object DataSet object via a DataAdapter

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

DataReader Object : 

DataReader Object Provides methods and properties that deliver a forward-only stream of data rows from a data source When a DataReader is used, parts of the ADO.NET model are cut out, providing faster and more efficient data access

Create DataReader Example : 

Create DataReader Example

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

DataAdapter Object : 

DataAdapter Object Provides a set of methods and properties to retrieve and save data between a DataSet and its source data store Allows the use of stored procedures Connects to the database to fill the DataSet and also update the database

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

DataSet Object : 

DataSet Object Replaces the ADO Recordset Represents a cache of data that contains tables, columns, relationships, and constraints, just like a database Regardless of where the source data comes from, data can all be placed into DataSet objects Tracks changes that are made to the data it holds before updating the source data DataSet are also fully XML-featured Works with all current models of data storage: flat, relational, and hierarchical

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

DataView Object : 

DataView Object Provides methods and properties that enable UI objects such as a DataGrid to bind to a DataSet A view of the data contained in the DataSet Only used in conjunction with a DataSet

Agenda : 

Agenda ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

Create Data Access Windows Form : 

Create Data Access Windows Form

Create Multiple Table DataSet Example : 

Create Multiple Table DataSet Example

Summary : 

Summary ADO versus ADO.NET ADO.NET Architecture Connection Object Command Object DataReader Object DataAdapter Object DataSet Object DataView Object Use ADO.NET to access data in an application

New Hampshire Access/Visual Basic User Group : 

New Hampshire Access/Visual Basic User Group Meets 4th Wednesday of each month Meetings held at Southern New Hampshire University Link to Information - http://www.jjssystems.net