hi,
How to overcome, i have table 130,000 record when running query appeared message like below.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Thanks
Hi ahmadsubuhanl...,
You need to increase the TimeOut. The default value is 30 seconds.
It is better to use custom paging for fetching the data, instead of fetching all the records.
Only the required no of records will be fetched from the table.
For more details refer Custom Paging in ASP.Net GridView using SQL Server Stored Procedure.
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.