grid Filter issues

[Soumya]

Please help me on the below issues in Radgrid.I am using NeedDataSource for binding the grid.

1)I have a radgrid and filter with textbox(AutoPostBackOnFilter="true" ShowFilterIcon="false" CurrentFilterFunction="Conatins") for Name. 
On typing letters in the filter textbox ,for example  if I type 'MUH',the GRID should be filled with all records with name starting with 'MUH' ,without pressing enter.
2)In GridDateTimeColumn,I have given filter option as "PickerType="DatePicker" EnableRangeFiltering="true"".Here in the filter box I am having filter options as BETWEEN,NOT BETWEEN,IS NULL,NOT IS NULL,NO FILTER.
Can I have the Filter with options BETWEEN & NOT BETWEEN only?
3)I have entered a name in filter textbox for Name column,pressed enter,fetched corresponding record.Now if I press Refresh button,I need to clear the textbox,and refresh the grid populated with all data.
Presently,my grid is showing the filtered record on refresh.

Highly appreciate your help on this.
Thanks,
Soumya

[Eyup]

Hi Soumya,

For the first requirement you could us the following property:

<telerik:GridBoundColumn ... CurrentFilterFunction="StartsWith" FilterDelay="2000">

In addition, you could check out the Google-like filtering functionality:
 Grid / Google-like Filtering

As for restricting some of the menu options, please refer to the topic below:
 Reducing the Filter Menu Options

The refresh button of the GridCommandItem only rebinds the grid without changing its Viewstate, therefore the grid preserves its filtered state upon refreshing. To reset the grid to its initial state, you could use the following approach:

protected void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.MasterTableView.SortExpressions.Clear();
    RadGrid1.MasterTableView.GroupByExpressions.Clear();
    RadGrid1.CurrentPageIndex = 0;
    RadGrid1.MasterTableView.FilterExpression = "";
    RadGrid1.EditIndexes.Clear();
    RadGrid1.MasterTableView.IsItemInserted = false;
    RadGrid1.Rebind();
}

I hope this will prove helpful.

All the best,
Eyup
the Telerik team