So here is the situation:
I have a RadGrid with 4 columns and am allowing filtering. I'm using the <FilterTemplate> for all four columns and am binding using the NeedDataSource event.
Everything is working great except that for one of the fields I want to actually requery the database rather than just filter. It is a date field and I would rather limit the results from the database on this filter rather than just filter the existing data.
Sooo...here is what I tried:
RadComboboxEmployeeDateSubmittedFilter is the combobox that is inside the DateSubmitted column <FilterTemplate>, so the code above fires when the user selects an item from the combobox.
Here is my NeedDataSource handler:
As you can see it is referencing the _startDate and _endDate fields which get populated when the user makes a selection from the dropdown.
The problem is that RadGridEmployeeTransactions.Rebind() does not cause the
RadGridEmployeeTransactions_NeedDataSource event to fire, which means the database is not re-queried and the results are not filtered.
How do I go about forcing the RadGridEmployeeTransactions_NeedDataSource event to fire so that it queries the database with the correct _startDate and _endDate values??
Thanks!