ADO1 - Database Connectivity with ADO.NET Overview ADO.NET...

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

View Full Document Right Arrow Icon
Database Connectivity with ADO.NET
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Overview Overview ADO.NET Architecture Data Access Using Server Explorer Database Connection Working with ADO.NET Adapters Data Adapter Wizard Working with ADO.NET Datasets Accessing Data Cells Other ADO.NET Objects – Data readers, Data views
Background image of page 2
3 Use VB.NET controls to display and manipulate data residing in the underlying databases ? ADO .NET (ActiveX Data Objects) acts as a bridge between VB .NET controls and the underlying database. ADO .NET is the collection of classes (objects) that are designed to support data access and data manipulation. Introduction Introduction
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 ADO.NET Architecture ADO.NET Architecture At a higher level glance Data Connection – Connects to the database Data adapter – Query a database table using SQL Dataset – Stores the data returned by a data adapter
Background image of page 4
5 ADO.NET Architecture ADO.NET Architecture Detailed architecture
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Data Access Using Server Explorer Data Access Using Server Explorer Server explorer allows us to create data connections with various data sources. It also displays the list of tables and views (queries) for established data connections.
Background image of page 6
7 Data Access Using Server Explorer Data Access Using Server Explorer Example Display the student table from University database on Windows form using the server explorer. Step 1 – Make a connection with the database
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 Data Access Using Server Explorer Data Access Using Server Explorer Select the Microsoft Jet 4.0 OLE DB Data Provider
Background image of page 8
9 Data Access Using Server Explorer Data Access Using Server Explorer Select the University database using the Select Access Database dialog . Test and verify the connection .
Background image of page 9

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

View Full DocumentRight Arrow Icon
10 Data Access Using Server Explorer Data Access Using Server Explorer Step 2 – Create a data adapter Drag the tblStudent from table listing in Server Explorer on Windows Form1.
Background image of page 10
11 Data Access Using Server Explorer Data Access Using Server Explorer Step 3 – Create a dataset Generating Dataset - options
Background image of page 11

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

View Full DocumentRight Arrow Icon
12 Data Access Using Server Explorer Data Access Using Server Explorer Generate Dataset Dialog Component Tray
Background image of page 12
13 Data Access Using Server Explorer Data Access Using Server Explorer Step 4 – Bind the Dataset to a Control Add a Data Grid control on Form 1 from a Toolbox Bind
Background image of page 13

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

View Full DocumentRight Arrow Icon
14 Data Access Using Server Explorer Data Access Using Server Explorer Step 5 - Write two lines of VB.NET code
Background image of page 14
15 Data Access Using Server Explorer Data Access Using Server Explorer Output in data grid
Background image of page 15

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

View Full DocumentRight Arrow Icon
16 Data Access Using Server Explorer Data Access Using Server Explorer Steps for database connectivity - Summary Create a database connection using Server Explorer. Drag a table from the Server Explorer on a form to automatically
Background image of page 16
Image of page 17
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 50

ADO1 - Database Connectivity with ADO.NET Overview ADO.NET...

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

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