And then click again close the command and parameter editor dialog box

230 CHAPTER 6 ■ INLINE AND LIST BINDING

14. Click the Query Builder button to launch the Query Builder dialog box. As shown in Figure 6-16, add @ManufacturerID as the filter for the PlayerManufacturerID column. You can click the Execute Query option to test that the query is correct.

15. Click the OK button to close the Query Builder, and then click OK again to close the Command and Parameter Editor dialog box.

Figure 6-16. Using the Query Builder to filter the list of Manufacturers

If you look at the HTML markup for SqlDataSource1, you’ll see that apart from the ID and runat properties that all Web controls have, the SqlDataSource has two other properties that enable you to configure the Web control for your purposes: ConnectionString and SelectCommand.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SqlConnectionString %>"
SelectCommand="SELECT ManufacturerID, ManufacturerName FROM Manufacturer"> </asp:SqlDataSource>