Click here to Skip to main content
15,887,871 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
I am new to WPF.

In my wpf application, I have a Window with a DataGrid, I load records from database to the DataGrid using Linq lambda expression.

The records are loaded during window's initialization, due to the large number of records in database, window initialization takes a long time and the application becomes unresponsive.

Please Every one Help me As soon as........
Posted
Comments
Kornfeld Eliyahu Peter 16-Dec-14 8:15am    
Use paging for your data...

1 solution

You have to implement pagination in order to optimize your application speed. There are articles about this also on CodeProject like the next one:
WPF - Paging in DataGrid / ListBox[^]

PS: I have also an article about pagination into an ASPX application where I provide pagination at the database level into a stored procedure that could be reused also by you. Here is the link: Advanced ASPX GridView Pagination and Data Entities[^]
 
Share this answer
 
Comments
BillWoodruff 16-Dec-14 8:36am    
+5
Raul Iloc 16-Dec-14 8:49am    
Thank you for your vote!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900