October 2010
Intermediate to advanced
1920 pages
73h 55m
English
Content preview from ASP.NET 4 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Connecting to Microsoft SQL Server
By default, the SqlDataSource control is configured to connect to Microsoft SQL Server version 7.0 or higher. The default provider used by the SqlDataSource control is the ADO.NET provider for Microsoft SQL Server.
You represent a database connection string with the SqlDataSource control’s ConnectionString property. For example, the page in Listing 9.1 includes a SqlDataSource control that connects to a local SQL Server 2008 database (see Figure 9.1).
Figure 9.1. Displaying the Movies database table.
Listing 9.1. ShowLocalConnection.aspx
In Listing 9.1, the SqlDataSource control uses the following connection ...