This page is specific to

Microsoft Visual Studio 2005/.NET Framework 2.0

Other versions are also available for the following:

Want more? Here are some additional resources on this topic:

Using DataSets in ADO.NET

.NET Framework Developer's Guide

ADO.NET

ADO.NET is a set of classes that expose data access services to the .NET programmer. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers.

In This Section

What's New in ADO.NET: Introduces features that are new in ADO.NET.

Overview of ADO.NET: Provides an introduction to the design and components of ADO.NET.

Securing ADO.NET Applications: Describes secure coding practices when using ADO.NET.

Using DataSets in ADO.NET: Describes how to create and use DataSets, typed DataSets, DataTables, and DataViews.

Connecting and Retrieving Data in ADO.NET: Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.

Modifying Data in ADO.NET: Describes how to modify data in a database and how to use transactions.

Using the .NET Framework Data Provider for SQL Server: Describes how to work with features and functionality that are specific to SQL Server.

Using the .NET Framework Data Provider for Oracle: Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.

Using SQL Server Common Language Runtime Integration: Describes how data can be accessed from within a common language runtime (CLR) database object in SQL Server 2005.

Writing Provider-Independent Code in ADO.NET: Describes generic classes that allow you to write provider-independent code in ADO.NET.

Performing General Tasks in ADO.NET: Describes how to use various general-purpose features of ADO.NET.

Finding Additional ADO.NET Information: Provides links to additional online information about ADO.NET.

Related Sections

Building ASP.NET Applications: Provides instructive overviews and detailed, step-by-step procedures for creating ASP.NET Web applications in the .NET Framework.

Windows-based Applications: Provides detailed information about working with Windows Forms and console applications.

Core Development Technologies: Provides links to information about standard development tasks in the .NET Framework.

Advanced Development Technologies: Provides links to information on sophisticated development tasks and techniques in the .NET Framework.

Samples and QuickStarts: Provides complete listings of all samples and QuickStart samples associated with the .NET Framework.