Timeout expired

Hi Hemant Jindal,

i debug my code ,that is not going to close connection here is my code and below i mentioned with red color con.close...

ReportDocument rpt = new ReportDocument();
SqlConnection con = new SqlConnection("Data Source=ATLANTIC\\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=SilverProduction;MultipleActiveResultSets=True;");
protected void Page_Load(object sender, EventArgs e)
{
{
if (Session["EmpID"] == null)
{
Response.Redirect("LogingForm.aspx");
}
rpt.Dispose();
rpt.Close();
loadReport();
}
}
private void loadReport()
{
DuplicatePV.Dispose();
rpt.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
//SqlConnection con = new SqlConnection();
try
{
con.Open();
SqlCommand cmd = new SqlCommand("spSelectOrderDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OrderNo", TextBox1.Text);
// cmd.Parameters.AddWithValue("@OrderNo", 10001676);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet dt = new DataSet();
da.Fill(dt);
//SqlDataAdapter adp = new SqlDataAdapter("select prdno,orderno,Codeitem,prdqty from probale", con);
//DataSet ds = new DataSet();
//adp.Fill(ds);
rpt = new ReportDocument();
DuplicatePV.RefreshReport();
rpt.Load(Server.MapPath("~/Bigbal.rpt"));
//rpt.Load(Server.MapPath("Bigbal.rpt"));
rpt.SetDataSource(dt.Tables["Table"]);
// rpt.PrintToPrinter(1, false, 1, 1);
DuplicatePV.ReportSource = rpt;
//rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, True, "Bigbal");
rpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "Probale");
rpt.Close();
rpt.Dispose();
con.Close();
}
catch (Exception ex) { }
}
protected void CRBigview_Unload(object sender, EventArgs e)
{
try
{
rpt.Close();
rpt.Dispose();
con.Close();
}
catch { }
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hemant Jindal7y ago
Accepted answer
hope this link https://blogs.msdn.microsoft.com/angelsb/2004/08/25/connection-pooling-and-the-timeout-expired-exception-faq/ might help you
Akhter HUssain7y ago
Hi Hemant Jindal,
i debug my code ,that is not going to close connection here is my code and below i mentioned with red color con.close...
ReportDocument rpt = new ReportDocument();
       SqlConnection con = new SqlConnection("Data Source=ATLANTIC\\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=SilverProduction;MultipleActiveResultSets=True;");

       protected void Page_Load(object sender, EventArgs e)
       {
           {
               if (Session["EmpID"] == null)
               {
                   Response.Redirect("LogingForm.aspx");
               }
               rpt.Dispose();
               rpt.Close();
               loadReport();

           }
       }
       private void loadReport()
       {
           DuplicatePV.Dispose();
           rpt.Close();

       }
           protected void Button1_Click(object sender, EventArgs e)
       {
           //SqlConnection con = new SqlConnection();

           try
           {
               con.Open();
               SqlCommand cmd = new SqlCommand("spSelectOrderDetail", con);
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.Parameters.AddWithValue("@OrderNo", TextBox1.Text);
               // cmd.Parameters.AddWithValue("@OrderNo", 10001676);
               SqlDataAdapter da = new SqlDataAdapter(cmd);
               DataSet dt = new DataSet();
               da.Fill(dt);
               //SqlDataAdapter adp = new SqlDataAdapter("select prdno,orderno,Codeitem,prdqty from probale", con);
               //DataSet ds = new DataSet();
               //adp.Fill(ds);


               rpt = new ReportDocument();
               DuplicatePV.RefreshReport();
               rpt.Load(Server.MapPath("~/Bigbal.rpt"));
               //rpt.Load(Server.MapPath("Bigbal.rpt"));
               rpt.SetDataSource(dt.Tables["Table"]);
               // rpt.PrintToPrinter(1, false, 1, 1);
               DuplicatePV.ReportSource = rpt;

               //rpt.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, True, "Bigbal");
               rpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, false, "Probale");
               rpt.Close();
               rpt.Dispose();
               con.Close();
           }

           catch (Exception ex) { }
       }

       protected void CRBigview_Unload(object sender, EventArgs e)
       {


           try
           {
               rpt.Close();
               rpt.Dispose();
               con.Close();


           }
           catch { }
       }

   }