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

FilterExpression, After or Before Get Data?

3 Answers 35 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Oliver
Top achievements
Rank 1
Oliver asked on 17 Jul 2010, 01:40 PM
i used this code:
RadGrid1.MasterTableView.FilterExpression = filterExpression

and get data by this code:
Private Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
        RadGrid1.DataSource = From o In en.tblSuggests Select o
End Sub

But, i have a ask.
filter operating is before get data or after Get data ?
my table having 60,000 records.

3 Answers, 1 is accepted

Sort by
0
Iana Tsolova
Telerik team
answered on 21 Jul 2010, 03:25 PM
Hello Oliver,

With the preceding set up, all data will be first retrieved from the server and then the grid will filter them. However if you bind the grid to a DataSource control which supports filtering, like the LinqDataSource, the grid will arse the filter expression to the LinqDataSource and data will be first filtered on the server and then only the filtered records will be returned.

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
Oliver
Top achievements
Rank 1
answered on 22 Jul 2010, 07:13 PM
Thank you for answer me.
your suggest to me , i useing LinqDataSource.
i need document or sample for this way.
my record is 150,000 record in a table .
you can help me?
0
Iana Tsolova
Telerik team
answered on 23 Jul 2010, 07:41 AM
Hello Oliver,

In fact there is nothing special when you are binding the grid to LinqDataSource. You can check how this is done in this online demo.

Try it out and let me know if any questions arise.

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
Tags
Grid
Asked by
Oliver
Top achievements
Rank 1
Answers by
Iana Tsolova
Telerik team
Oliver
Top achievements
Rank 1
Share this question
or