SQL query Timeout error in ASP.NET -


i have asp.net web app show data sql server 2008 standard edition, data sql server inserted every time windows tool inserting records in bulk.

when view reports getting timeout error, applied command timeout=0 in sql command databind grid. keeping on loading when close current page , open page

execute reader requires open connection.
or
timeout error.

i don't know how resolve this. have applied nolock in sql queries in joins still getting error. created 2 instances of sql database; 1 tool , 1 web still timeout error.

could please me resolve this.

bigger timeout time?

put web.config;

<system.web> <customerrors mode="off"/> <httpruntime apprequestqueuelimit="100" executiontimeout="60000" /> </system.web> 

Comments