Creating winForm C# for importing data to datagrid from excel and using buffer to load items on scrool

Question

Hello iam new to this forum and i would like to know how to create buffer on items imported from excel? to speed up scroling if there is more dan 20000 records.. thank you

Suthish Nair · Answer

Are you saving the excel records to DB table first and then retrieving and binding them to datagrid ? If yes instead of showing whole records I would like suggest you to do procedure level pagination for binding the records.

Creating winForm C# for importing data to datagrid from excel, and using buffer to load items on scrool