title: Time out Exception in C#.net
body: <pre><code> 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;
  
      }
  </code></pre>
  
  <p><strong>Exception ::</strong></p>
  
  <pre><code>"Timeout expired.  The timeout period elapsed prior to completion of 
      the operation or  the   server is not responding."
  </code></pre>
  
  <p>When I pass parameters to stored procedure its caught an exception and displaying above
  message".How to increase command timeout to 200 in <code>webconfig</code> file. I searched in google
  but no optimized result.</p>