This customization filters the contents of a field filter dropdown list.

Filters can be populated in two different ways.

  A. All possible values.

  B. Only values contained in the result set (current query for the table).

Option A or B can be selected in the Display tab of the Properties dialog for the filter.

Option A will populate filter with all the values from its parent table.

Option B will populate filter based on the result set.

For example CustomerID field in Orders table is a foreign key to CustomerID field in Customers table.

If option A is selected then CustomerID filter in Show Orders Table page will be populated from the Customers table.

If option B is selected then the CustomerID filter in Show Orders Table page will be populated with all the values of CustomerID in Orders table(results that would be returned based on the whereClause).

This customization assumes that the filter is populated with all possible values.

This customization will be added in:

..\<Application Name>\App_Code\<Table Name>\Show<Table Name>Table.Controls.cs

For example: C:\MyApp1\App_Code\Customers\ShowCustomersTable.Controls.cs

Step 1:  Use this wizard to add code customization.

Step 2:  Build and run the application.

This customization only applies to pages with table controls.