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
Filtering Database Rows
The SqlDataSource control includes a FilterExpression property that enables you to filter the rows returned by the control. You can define complex Boolean filters that include parameters with this property.
For example, the page in Listing 9.10 retrieves all movies that have titles that match the string entered into the TextBox control (see Figure 9.6).
Figure 9.6. Show matching movies.
Listing 9.10. ShowFilterExpression.aspx
In Listing 9.10, the FilterExpression includes the LIKE operator and the % wildcard character. ...