Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
and then click again close the command and paramet

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


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>

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Danielle Lane-Cooper

PageId: ELI0D18F14