c# - Show a huge number of data in DevExpress GridView -

With 3000 lines I have a DevExpress grid view and each row has 10 as extensions (this means that when I have 30000 loads in grid load items to load)

All data loads It takes a long time to do so, then there is a way to show example 100 lines, and when I use the automatic filter, do I show the lines I want?

Example

I tried to leave and take (using LINQ), but what I actually see for it Also want to use the automatic filter of the grid.

  Public Static Binding List & lt; Patient & gt; GetObjectUsingLinq (string sql = "", int skipCount = 0, int lekton = 0) {var gsData = GetDataContext (); Var query = (to choose q.nom q with GS dataApotate order); Return new compulsory list & lt; Patient & gt; (LinqHelper.DoSortPaginate (Query, "" Leave, Techcount) .Oolist ()); }   
 and to call it on the grid  
  listPatient = patients.getObjectUsingLinq (); myGrid.DataSource = listPatient;    
 
 
 If you need to display large amounts of records in the grid control, then you You can use  Server Data Binding Mode  (Synchronous) or these are specially designed to work with a large set of data with more than 50,000 records. 
 Take a look to get started with these modes. With excitrgrid and LINQ, you can start here: 
  
    Data-aware DevExpress control for data source ( Such as grid control) simplifies the process of binding