[Solved] Google Like Filtering In RadGrid

[Monalisa]

Hi Telerik,

I use the Google Like filtering in my application. It works fine. But I need small changes.
When I first click on the Filter textbox, it loads everything from database and shows it in a Combo.
What I need is at the time of first click on the textbox it should not select any thing from database, because  there is heavy load to server, after typing something in that textbox then it should select from database.

So, how to do this. Please suggest.

Thanks,
Monalisa

[Sebastian]

Hello Monalisa,

To avoid the loading of items when no value is typed in the RadComboBox input area, consider modfying the OnItemsRequested event handler of the combo in the MyCustomFilteringColumnCS.cs file of the relevant demo as follows:

private void list_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e)
{
   if(e.Text != String.Empty)
   {
    ((RadComboBox)o).DataTextField = this.DataField;
    ((RadComboBox)o).DataValueField = this.DataField;
    ((RadComboBox)o).DataSource = GetDataTable("SELECT DISTINCT " + this.UniqueName + " FROM Customers WHERE " + this.UniqueName + " LIKE '" + e.Text + "%'");
    ((RadComboBox)o).DataBind();
   }
}

Best regards,
Sebastian
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Monalisa]

Hi Sebastian,

Thank you very much for your support, it's working fine.

Thanks,
Monalisa