How to use a timeout with SQL database connections.
Zhang Zhao, Dec 24, 2012
you don't need to change the data access.
You can modify your connection string to include a timeout value:"Data Source=144681;Initial Catalog=Customer;Timeout=60;Persist Security Info=True;User ID=xxxxx;Password=yyyyy"
Set this connection string in Hosting layout->Web.config file:
<add name="ADO.NET.SqlServer" connectionString=" [your connection string with timeout ] "/>
I'm not sure what is your mean of 2 & 3 but i guess BeginExecute and EndExecute Methods in SqlCommand object can help you.
Mohammad Reza Khahani, Jan 05, 2013
Everyone, who can help me? especially the question 2 & 3.
Zhang Zhao, Dec 25, 2012