0

I am populating a set of results in asp.net grid-view from a stored procedure. That stored procedure is very huge and taking some time to return the results. While executing that stored procedure its taking two minutes , but I am able to see the results in the SQL Server Editor. But in grid-view it is not loading and I am getting time out error.

Can any one please suggest me the solution?

Error Details:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Improve this question
1
  • Where is your code ?? Commented Nov 20, 2015 at 7:12

2 Answers 2

Reset to default
0

As You have not post your source code, i can suggest you to have a look here,

Poor Performance with Sqlparameter

Timeout Expiry issues.<- Refer this answer

Apart from that, its always preferred to load the data you can see on the single page. Loading more then 200 records in a grid view is not preferable. It will obviously slow down your screen.

Load on demand is the approach you can look forward to load your grid view . Load On Demand GridView

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Thanks all for the solutions. Anyway I fixed this issue , by increasing command time out time. It works :)

Thanks Again.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.