Using ADO.NET

Paul D. Sheriff
PDSA, Inc.

January 2002

Summary: Discusses using ADO.NET Connection object, other ADO.NET objects, and provides examples. (41 printed pages)

Objectives

• Learn to create a Microsoft® ADO.NET Connection object
• Submit SQL through an ADO.NET Command object
• Use the ADO.NET DataReader class
• Learn to load objects into a list box
• Use DataTable objects and DataSet objects
• Modify data using DataSet objects

Assumptions

The following should be true for you to get the most out of this document:

• You understand relational databases
• You are familiar with ADO
• You understand how to build Microsoft Windows® Forms
• You are familiar with and have access to Microsoft SQL Server™ or some other database, like Microsoft Access

Contents

ADO.NET Connection
The ADO.NET Command Object
Using the ADO.NET DataReader
Using ADO.NET DataTables and DataSets
What's Different Between Visual Basic 6.0 and ADO?
Summary

Chi tiết: http://msdn2.microsoft.com/en-us/library/aa302325.aspx