sql time ouy

I have a report which contains many sqls.when ı execute it from designer there isnt any timeout problem.but when i use it in a c# project there is a timeout problem like 'System.Data.SqlClient.SqlException was unhandled by user code'


detail Message=Timeout expired. The timeout period elapsed completion of the operation or the server is not responding.

Comments

  • edited 11:34PM
    Hello,

    The timeout may be set for the connection object. Switch to the Data window, select the connection, set its CommandTimeout property in the Properties window.
  • edited 11:34PM
    nop. i changed the connection time out to 60 but still this report can run from designer but not in project..in project the same report is throw exception sql timeout error
  • edited 11:34PM
    Could you show me an exception stack trace?
  • edited September 2011
    i cant take this exception now bacause of the system density. Report is working now. But i have no idea why that happend.I think it is about sql command timeout.Because there is no problem about connection

Leave a Comment