Duration: 24 minutes
Summary: In this video, we continue our discussion of working with data controls. We discuss using filters and working with cookie parameter. We start with the filter. We create a GridView. The SqlDataSource associated with the grid has a select command and a filter expression. The value that feeds into the filter expression is from a filter parameter. The filter parameter uses a control parameter connected to a text box on the page. That way, when the user types something in the text box and click the button, the grid will filter accordingly. In the second part of the video, we talk about using cookie parameter. A cookie is a small file that the browser can use to remember information. You can make a cookie last for a long time by setting its expire property. In our case, we add a DetailsView with a SqlDataSource. The select command of the data source is using a variable that is driven by the cookie parameter. The default value for the details view is to display 15 records. If the cookie is available, that value will be 5. We made the cookie to expire in 20 seconds.
Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.
Technology Used: ASP.NET and Visual Studio 2010
Keyword: ASP.NET 4, Visual Studio 2010, TextBox, Button, GridView, SqlDataSource, SelectCommand, ConnectionString, FilterExpression, FilterParameters, ControlParameter, DetailsView, SelectParameters, CookieParameter.