Sql Helper RRS feed

  • Question

  • User2101710649 posted


     I am using sql Helper for Data Access.I am implemented the connection pooling in web.config. I have 10000 records.I am using view to retrive the record from different tables from sqlserver. I got the Error  is below while access from application.

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

    Please give me the any solution for this problem.




    Saturday, August 29, 2009 6:12 AM

All replies

  • User-158764254 posted

    The old SQLHelper class does not give you access to the CommandTimeout setting so you only get the default 30 seconds.

    If you want to change the timeout, you'd need to alter the SQLHelper code slightly (http://bytes.com/topic/c-sharp/answers/513212-increase-daab-time-out)

    Or you could skip SQLHelper and create your own SQLCommand for your long running calls


    Saturday, August 29, 2009 8:22 AM