Hi sir,
how to set command timeout for sqlhelper class. I am getting error like
"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
in
SqlHelper.ExecuteNonQuery(connection, CommandType.StoredProcedure, "UpdateFormData", Params);
Web.config:
<connectionStrings>
<clear/>
<add name="dmw_con" providerName="System.Data.SqlClient" connectionString="Data Source=LBIT00046;Initial Catalog=DMW_Reports;User ID=sa;password=welcome;Connect Timeout=200; pooling=true; Max Pool Size=600;Timeout=360"/>
<add name="ret_con" providerName="System.Data.SqlClient" connectionString="Data Source=lbit00046;Initial Catalog=Retailer_FormDB;User ID=sa;password=welcome;Connect Timeout=200; pooling=true; Max Pool Size=600;Timeout=360"/>
</connectionStrings>
With regards,
J.Prabu.
[Email:prbspark@gmail.com]