Always good to know
Source Error:
Line 114: myParam.Direction = ParameterDirection.ReturnValue
Line 115:
Line 116: myCommand.ExecuteNonQuery()
Line 117: 'Call Response.Write("JS VAL : " & usrName & ":" & myCommand.Parameters("RETURN VALUE").Value & ":" & myCommand.Parameters("@usrmemberType").Value())
Line 118: usrpwd = myCommand.Parameters("@usrpwd").Value
Source File: E:\TRC\admin\Login.aspx.vb Line: 116
Stack Trace:
[InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.]
System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) +4874932
System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +11
System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +144
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +105
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
Admin_Login.mailadmpassword(String usrName) in E:\TRC\admin\Login.aspx.vb:116
Admin_Login.btnpwd_Click(Object sender, EventArgs e) in E:\TRC\admin\Login.aspx.vb:66
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565