Load more than 90000 records data to gridview at form_load

Question

how to handle to load more than 90000 records data to gridview. I used datatable as datasource. now It takes almost 2 mins

Amit Gupta · Answer

DataSource do not take much time to bind it with gridview, it depends how you fetch the data. You can use Store Procedure to reduce the traffic or you can use pagination function so that data can be fetched 10 records (for eg) at a time.

sudipta sanyal · Answer

For this you need to use CTE query for better performance, why you load full table data at one time, load data page by page. DECLARE @Pagesort VARCHAR(20) = '', @Pageorder VARCHAR(10) = 'ASC', @PageNumber INT = 1, @PageSize INT = 50 SELEct @PageNumber = 1 IF (@PageNumber SET @PageNumber = 1 CREATE TABLE #temp_table (ID INT IDENTITY(1,1), text NVARCHAR(200)) ;WITH n(n) AS ( SELECT 0 UNION ALL SELECT n+1 FROM n WHERE n ) INSERT INTO #temp_table (text) SELECT [text] = 'text_'+CONVERT(VARCHAR(10),n) FROM n ORDER BY n OPTION (MAXRECURSION 1000); --SELECT * FROM #temp_table --**************************************** ; WITH Results_CTE AS (SELECT ID, text FROM #temp_table ) SELECT ROW_NUMBER() OVER (ORDER BY ID ) AS rownum, COUNT(*) OVER () AS rowcnt, * FROM Results_CTE ORDER BY rownum OFFSET @PageSize * (@PageNumber - 1) ROWS FETCH NEXT @PageSize ROWS ONLY DROP TABLE #temp_table

Ye Htut · Answer

I am developing the windows application.

ali tuncer · Answer

if you just need to display 90000 rows of data all at once, try binding to a repeater, it will be faster than gridview..

Ye Htut · Answer

Although the user doesn't use all data, I have to display all. in my code, datatable is used to bind data to grdview.

Nitin Sontakke · Answer

Can you please elaborate on what exactly you are going to do with all those records filled in GridView? No user is going to ever look at all these records, which is the sole purpose of such a control.

Load more than 90000 records data to gridview at form_load

Answers (6)