IS437: Spring 2006 Instructor: Dr. Boris Jukic - PowerPoint PPT Presentation

About This Presentation
Title:

IS437: Spring 2006 Instructor: Dr. Boris Jukic

Description:

Introduction to ADO.Net The ... Provider Microsoft Access Microsoft Jet 4.0 OLE DB Provider Connection database Adapter customer dataset SQL 3 1 ... or Oracle , etc ... – PowerPoint PPT presentation

Number of Views:96
Avg rating:3.0/5.0
Slides: 11
Provided by: Fisher87
Category:

less

Transcript and Presenter's Notes

Title: IS437: Spring 2006 Instructor: Dr. Boris Jukic


1
IS437 Spring 2006Instructor Dr. Boris Jukic
  • Interacting with a Database ADO.Net

2
Introduction to ADO.Net
  • The basic ActiveX Data Objects model
  • Creates a connection to the database
  • Binds data to controls

3
Connecting the Database with the Client
Application
database
Project
invoice
Form1 Form2
customer
invoice line item
part

Provided by Access, or Oracle, etc.
4
ADO.Net A Disconnected Model
Project
database
Form1 Form2
invoice
customer
invoice line item
part

resides in the local machine
Provided and Managed by Access, or Oracle, etc.
5
How to create a dataset
database
3
SQL
Adapter
1
Microsoft Access
Provider
Connection
Microsoft Jet 4.0 OLE DB Provider
2
6
How to create a dataset
  • Step 1 select a provider, a database to connect
    to, and specific table from the database to work
    with. Drag the chosen table onto the form and an
    instance of OleDbDataAdaper (OleDbDataAdapter1 by
    default) is placed in the data tray.
  • Step 2 From the Data menu, select Generate the
    dataset

7
How to create a dataset Step 2
At the completion of Step 2, a dataset (dataset11
by default) is placed in the component tray.
8
How to create a dataset
  • Step 3 Fill the dataset with data. Place the
    following code in the form load event.
  • OleDbAdapter1.Fill(Dataset11)
  • OldDbAdapter1 is the name of the adapter,
    Dataset11, the name of the dataset.

9
Project
database
Form1 Form2
invoice
customer
invoice line item
part

resides in local machine
Managed by Access, or Oracle, etc.
10
Bind data to controls
Write a Comment
User Comments (0)
About PowerShow.com