The SqlDataSource control enables you to use a Web control to access data located in a relational data base, including Microsoft SQL Server and Oracle databases, as well as OLE DB and ODBC data sources. You can use the SqlDataSource control with other controls that display data, such as the GridView, FormView, and DetailsView controls, to display and manipulate data on an ASP.NET Web page, using little or no code.

The topics in this section describe how to use the SqlDataSource to connect to a database and retrieve and update data.

In This Section

SqlDataSource Web Server Control Overview

How to: Connect to a SQL Server Database Using the SqlDataSource Control

How to: Connect to an Access Database Using the SqlDataSource Control

How to: Connect to an ODBC Database Using the SqlDataSource Control

How to: Connect to an Oracle Database Using the SqlDataSource Control

Selecting Data Using the SqlDataSource Control

How to: Enable Filtering for the SqlDataSource Control

Using Parameters with the SqlDataSource Control

Modifying Data using the SqlDataSource Control

Caching Data with the SqlDataSource Control

Related Sections

Accessing Data with ASP.NET: Provides general information on using ASP.NET controls to work with data.

ASP.NET Web Server Controls Overview: Provides general information on working with ASP.NET Web server controls.

Data Web Server (ASP.NET) Controls: Provides information about ASP.NET controls you can use to connect to data sources.

Individual ASP.NET Web Server Controls: Provides information on other Web server controls.

Securing Data Access: Provides information on protecting access to data sources from security threats.