SqlDataSource
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.
The most common way to use a SqlDataSource control is to specify it in the Data Source Configuration Wizard when you set the Data Source of a data-bound control such as the GridView, FormView, DetailsView, DataList, or Repeater.
You can also add a SqlDataSource control to a page by dragging it from the Toolbox panel onto your page. When the control is on your page, right-click it and choose Properties to open the Tag Properties panel where you can set properties for the control.
Tip
Many ASP.NET controls do not have a visual representation at run time. The control is always visible in Code view. If you do not see a representation of the control in Design view, on the View menu, point to Visual Aids and then click ASP.NET Non Visual Controls.
For more information about using the SqlDataSource control, see SqlDataSource Web Server Control (Visual Studio) .png "Cc295347.xtlink_newWindow(en-us,Expression.40).png")
in the MSDN library.
See also
Concepts
Working with ASP.NET sites
ASP.NET Data controls
AccessDataSource
DataList
DetailsView
FormView
GridView
Repeater
SiteMapDataSource
XmlDataSource
Send feedback about this topic to Microsoft. © 2011 Microsoft Corporation. All rights reserved.