I'm playing with optimization in ASP.Net WebForms.

in my case I have 2 dropdowns and a grid.

I want the dropdowns to act as a filter for the grid, each containing a distinct list of the data in one column of the grid (to use as a filter)

That's fine.. I got it working, but I can't use the same datasource as the grid for the dropdowns anymore because I'm applying a filterexpression to the datasource to filter whats in the grid.

since its the same datasource as the dropdowns, I get a smaller distinct list in the dropdown.

now I can use multiple datasources, each consuming the same data object, but I see in Sql Profiler that 2 data calls are made, but I'd really like to use the same one so I can have a single data call.

is it even possible to have a single ObjectDataSource be filtered for the grid, and at the same time and provide unfiltered data for another control?