Help me this error: "Timeout expired. The timeout period elapsed prior to obtaining a connection fr...

Increase you pool size and time out and then try again..... :)

I use web service as a data access layer to get data. Code here: using System; using System.Collections; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data.SqlClient; using System.Data; using System.Configuration; ///

/// Summary description for WebService ///

[WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class WebService : System.Web.Services.WebService { SqlConnection sqlCon; SqlCommand sqlCmd; public WebService () { //Create a connection string sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnect"].ConnectionString); sqlCmd = sqlCon.CreateCommand(); } [WebMethod] public string HelloWorld() { return "Hello World"; } //Open connection public void Open() { if (sqlCmd.Connection.State == ConnectionState.Open) return; else sqlCmd.Connection.Open(); } //Dispose resource public void Dispose() { sqlCmd.Connection.Dispose(); sqlCmd.Dispose(); sqlCmd.Connection.Close(); sqlCon.Close(); } [WebMethod] public void AddParameters(String namePara, object value) { sqlCmd.Parameters.AddWithValue(namePara, value); } [WebMethod] public String ExecuteScalar(String commandText, CommandType type) { String row = ""; object obj = null; try { this.Open(); sqlCmd.CommandText = commandText; sqlCmd.CommandType = type; obj = sqlCmd.ExecuteScalar(); if (obj == null) row = ""; else row = obj.ToString(); } catch (Exception ex) { throw ex; } finally { sqlCmd.Dispose(); } return row; } [WebMethod] public DataSet ExecuteDataSet(String commandText, CommandType type) { SqlDataAdapter da; DataSet dset; try { this.Open(); sqlCmd.CommandText = commandText; sqlCmd.CommandType = type; da = new SqlDataAdapter(sqlCmd); dset = new DataSet(); da.Fill(dset, "table"); } catch (Exception ex) { throw ex; } finally { sqlCmd.Dispose(); } return dset; } [WebMethod] public int ExecuteNonQuery(String commandText, CommandType type) { int i = 0; try { this.Open(); sqlCmd.CommandText = commandText; sqlCmd.CommandType = type; i = sqlCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { sqlCmd.Dispose(); } return i; } }