Microsoft® SharePoint® Designer 2010 Unleashed

Configuring the Toolbox SqlDataSource Control

This section covers how to create a new SqlDataSource control from the ASP.NET Controls section of the Toolbox task pane and create a new connection to an SQL database.

To create a new SQL connection using the Toolbox task pane’s SqlDataSource command, use the following steps:

1. With your site open in SharePoint Designer, click the File tab. On the File page, click the Add Item left-hand menu item and then, under Pages, click New Page from Master. Click the v4.master page and then click the Create button.

2. In the New Web Part Page dialog, name the page categories.aspx and save it to the Site Pages library. If you have created other Wiki page libraries in your current site, then you also see additional ...