grid view edit and update problem

Question

0.00/5 (No votes)

See more:

I am using C#,asp.net 2.0,server 2005 and visual studio 2005
Can anybody help with the following error:

i have a gridview with edit and delete button... when i select an item from dropdownlist ,it will load gridview with database values.

when i edit the row in a grid view and press update button,,it takes some time and later it is giving error like :

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

please help me.
Thanks in Advance.
Regards,
Karan

Posted 10-Jun-11 1:25am

karan joshua

Updated 10-Jun-11 1:33am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ra-one · Answer 1 · 2011-06-10T01:48:00

This error occurs when a database query or stored procedure is not able to complete execution before a pre-set timeout period expires.

Do one thing

Increase the amount of time that ASP.NET waits for the database query to run before throwing an exception. Programmatically set the CommandTimeout property in the IDbCommand object in a code customization in your application. IDbCommand is a .NET Framework object. CommandTimeout specifies the amount of time in seconds that .NET waits for the database query command to execute. Set that value high enough to exceed the amount of time required to execute your query or database stored procedure. You may need to adjust this timeout parameter on an application-by-application basis.

C#:

System.Data.IDbCommand.CommandTimeout = 50;

secondly,

Increase the amount of time that your database driver waits on your connection. This is different from the IDbCommand.CommandTimeout property. Both must be set properly for your query or stored procedure to run.

For more info visit[^]

Hope it helps ...... :)

thatraja · Answer 2 · 2011-06-10T01:49:00

Solution 2

Here you go

Troubleshooting: Timeout expired[^]

Posted 10-Jun-11 1:49am

thatraja

Comments

thatraja 10-Jun-11 8:03am

what about other cases? check the all possible situations in my answer link.

thatraja 10-Jun-11 8:14am

Probably you need to share the code, so include that in your question.