FilterExpression, After or Before Get Data?

[Oliver]

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.

[Iana Tsolova]

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

[Oliver]

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?

[Iana Tsolova]

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