Timeout expired

Question

i am facing below error. Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. please guide

Hemant Jindal · 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 HUssain · Answer

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 { } } }