SqlDataSource Web Server Control

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.