runat="server"
ProviderName="System.Data.SqlClient"
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
SelectCommand="Select ProductSubcategoryID, Name from Production.ProductSubcategory">
Categories:
runat="server"
DataSourceID="categoriesSource"
DataValueField="ProductSubcategoryID"
DataTextField="Name"
AutoPostBack="true"
ID="lstCategories">
ALL
runat="server"
ProviderName="System.Data.SqlClient"
CancelSelectOnNullParameter="false"
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
SelectCommand="Select ProductID, Name, ProductNumber, StandardCost from Production.Product WHERE ProductSubcategoryID = IsNull(@ProductSubcategoryID, ProductSubcategoryID)">
ConvertEmptyStringToNull="true" PropertyName="SelectedValue" />
HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True"
HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White" />