im using ragridview. the problem is if i have 100,000+ records and i want to display update and delete it on the grid. how do i improve the performance of the loading time. im using linq to sql.
1 Answer, 1 is accepted
answered on 20 Jan 2009, 11:34 AM
Thanks for your interest in RadControls for WinForms and RadGridView in particular.
One way to gain performance when using RadGridView with huge amounts of data is to load and show only separate portions of data. NET Framework 3.5 provides the infrastructure for such an implementation, as you already know - LINQ to SQL.
A simple scenario is to load some rows from the database and show them to the user. When the user requests another portion of the data, you query the database again and show the next data(page).
Please see this blogpost where a colleague of mine implemented paging in RadGridView: