This is a migrated thread and some comments may be shown as answers.

GoogleLike filtering on dataset

7 Answers 66 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Babu Puchakayala
Top achievements
Rank 1
Babu Puchakayala asked on 23 Sep 2010, 09:02 PM
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.

7 Answers, 1 is accepted

Sort by
0
Iana Tsolova
Telerik team
answered on 29 Sep 2010, 05:12 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Babu Puchakayala
Top achievements
Rank 1
answered on 29 Sep 2010, 04:02 PM
can you provide me any sample code?
0
Iana Tsolova
Telerik team
answered on 30 Sep 2010, 10:59 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Babu Puchakayala
Top achievements
Rank 1
answered on 30 Sep 2010, 08:06 PM
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?



0
Accepted
Iana Tsolova
Telerik team
answered on 01 Oct 2010, 11:27 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Babu Puchakayala
Top achievements
Rank 1
answered on 01 Oct 2010, 08:26 PM
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. 
0
Iana Tsolova
Telerik team
answered on 04 Oct 2010, 12:07 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Babu Puchakayala
Top achievements
Rank 1
Answers by
Iana Tsolova
Telerik team
Babu Puchakayala
Top achievements
Rank 1
Share this question
or