Time out Exception in C#.net

c#, c#-4.0

Solution

You can set it on your command object also

   cmd.CommandTimeout = 60;

Specify your time in seconds.

Problem

``` public DataTable GetDailycardReport(DailyReportPL dailyreportpl) { DataTable dtGetDailycardReport = new DataTable(); try { SqlParameter[] arParams = new SqlParameter[2]; arParams[0] = new SqlParameter("@farmername", typeof(string)); arParams[0].Value = dailyreportpl.farmername; arParams[1] = new SqlParameter("@batchno", typeof(int)); arParams[1].Value = dailyreportpl.batchno; dtGetDailycardReport.Load(SqlHelper.ExecuteReader(connection.ConnectionString, CommandType.StoredProcedure, "k_DailyCardreport", arParams)); } catch (Exception ex) { //DBExceptionPublisher exc = new DBExceptionPublisher(); //exc.Publish(ex); } finally { } return dtGetDailycardReport; } ``` Exception :: ``` "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." ``` When I pass parameters to stored procedure its caught an exception and displaying above message".How to increase command timeout to 200 in `webconfig` file. I searched in google but no optimized result.

Original source