GoogleLike filtering on dataset

[Babu Puchakayala]

Hi,

Can we do googlelike filtering on dataset. In the example you guys are doing filtering in sql query ( IN list_ItemsRequested Method). I ma using stored procedure to get the data. So i cant use stored procedure. So is there any way to do filtering on dataset. If yes how to do it. Please Let me know.

Thanks.

[Iana Tsolova]

Hi Babu,

You can bind the filtering RadComboBox to whatever data source you want. Just need to change the ItemsRequested event handler accordingly.

Best wishes,
Iana
the Telerik team

[Babu Puchakayala]

can you provide me any sample code?

[Iana Tsolova]

Hi Babu,

Like I previously mentioned, you only need to modify the code for binding the RadComboBox control in the ItemsRequested event. Can you elaborate on the issues you are facing when trying to implement this solution?

Kind regards,
Iana
the Telerik team

[Babu Puchakayala]

Hi lana,

in your code 

CType(o, RadComboBox).DataSource = GetDataTable("SELECT DISTINCT " & Me.UniqueName & " FROM Customers WHERE " & Me.UniqueName & " LIKE '" & e.Text & "%'")

 
Here you are doing filtering . The same way for the dataset (dsresult) how to do it? I mean i dont know how to get it?

[Iana Tsolova]

Hello Babu,

You can use the DataSet Select() method to pass it the filter expression we have in the sql query where clause. You can find more information on how to filter DataSets in the below online resources:

http://msdn.microsoft.com/en-us/library/b51xae2y%28VS.71%29.aspx
http://msdn.microsoft.com/en-us/library/1ay5y4w0%28v=vs.71%29.aspx

Best wishes,
Iana
the Telerik team

[Babu Puchakayala]

Hi Iana,

thanks for your reply. To use google like filter can i set autogeneratecolumns to false.. The thing is if i set autogeneratecolumns to false then I am getting a regular filter. Not Google like filter. 

[Iana Tsolova]

Hello Babu,

TheAutoGenerateColumns property should be set to false. And you need to add the custom columns dynamically. Chech the code of this demo again and see what differs in your case.

Kind regards,
Iana
the Telerik team