Timeout Property, how do i handle timeout RSS

• • Reply
  

  aminnagpure

  Member

  49 Points

  167 Posts

  Timeout Property, how do i handle timeout

  Aug 27, 2010 12:34 PM|LINK

  iam using technique mentioned in this tutorial

  i also added this AsyncTimeout="300" in page element

  
  

  http://www.asp.net/data-access/tutorials/efficiently-paging-through-large-amounts-of-data-vb

  
  

  the query is correct, how do i handle timeout

  
  

  Error in: searchresumes.aspx
  

  
  searchquery was countryid=1 and hide='N' and stateid='34' and cityid='347' and industryid='7' and jobcategoryid='3' and totalexp>=0 and totalexp<=1 and CONTAINS(entirecv, '"Freshers" or "call+center" or "bpo" or "kpo"')

  <div> <div>- Hide quoted text -</div> <div>
  Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  Stack Trace:
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at cvsearchnewTableAdapters.cvsearchpagingTableAdapter.cvsearchpagingcount(String criteria) in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\23cd83cd\eb83202e\App_Code.ktamhjyb.18.vb:line 713 at classcvsearchnew.TotalNumberOfProducts(String sq) in C:\Inetpub\wwwroot\job.com\wwwroot\App_Code\BLL\classcvsearchnew.vb:line 23 at classcvsearchnew.GetProductsPaged(Int32 startRowIndex, Int32 maximumRows, String sq) in C:\Inetpub\wwwroot\jobcom\wwwroot\App_Code\BLL\classcvsearchnew.vb:line 19 </div> </div>