
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.
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
0
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
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
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
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
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?
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
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
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.
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
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
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