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

Comments

Popular posts from this blog

Pass DB Connection parameters to a Kettle a.k.a PDI table Input step dynamically from Excel -

multithreading - PhantomJS-Node in a for Loop -

c++ - MATLAB .m file to .mex file using Matlab Compiler -