当我登录我的网页并注销时,再次使用另一个密码和用户及密码再次登录和注销......再次显示...它显示以下错误:
When I logged into my webpage and logout,,and again login and logout with another password and user and password..again again... Its shows the following error:
System.InvalidOperationException: 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. at Bal_Login.CheckDummy() in ...
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.
推荐答案
按照我之前的评论,这里是你的代码的格式化版本,其中我使用using语句。
Following my earlier comment, here is a formatted version of your code wherein I use the using statement. protected void ImgLogin_Click ( object sender, ImageClickEventArgs e ) { try { string command_string; string connection_string; command_string = "SELECT * " + "FROM tbl_login_user " + "WHERE username=@username AND " + "password=@password"; connection_string = ConfigurationManager. ConnectionStrings [ "constrings" ]. ConnectionString; using ( SqlConnection SQL_connection = new SqlConnection ( connection_string ) ) { SQL_connection.Open ( ); using ( SqlCommand SQL_command = new SqlCommand ( command_string, SQL_connection ) ) { SQL_command.Parameters.AddWithValue ( "@username", txtusername.Text ); SQL_command.Parameters.AddWithValue ( "@password", txtpwduser.Text); using ( SqlDataReader SQL_data_reader = SQL_command. ExecuteReader ( ) ) { SQL_data_reader.Read ( ); if ( SQL_data_reader.HasRows ) { Response.Redirect ( "~/Adminlogin/home.aspx", false); } else { msg.ShowAlertMessage ( "Invalid Login Credentials" ); } } } } } catch ( Exception ex ) { Response.Write ( ex.ToString ( ) ); } }
SQL_connection,SQL_command和SQL_data_reader都将关闭在每个使用语句块的末尾。
SQL_connection, SQL_command, and SQL_data_reader will all be closed at the end of each's using statement block.
代替using语句,你可以使用一个完成块,以确保在try块中打开的所有对象都已关闭。
In place of the using statements, you could use a single finish block to insure that all object opened in the try block are closed.
更多推荐
超时问题,而一次又一次登录
发布评论