For the Wrox United website, I've run into the below error when attempting to log in -- it seems to be a problem with login.aspx. Any help would be appreciated!

===

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.

Source Error:


Line 55: dbConnection.Open();
Line 56: System.Data.IDataReader dataReader;
Line 57: dataReader = dbCommand.ExecuteReader(System.Data.CommandBehavio r.CloseConnection);
Line 58:
Line 59: return dataReader;


Source File: C:\BegASPNET11\WroxUnited\admin\login.aspx Line: 57

Stack Trace:


[OleDbException (0x80040e10): No value given for one or more required parameters.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr) +41
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) +122
   System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) +92
   System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) +65
   System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) +112
   System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) +69
   System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior) +5
   ASP.login_aspx.Players() in C:\BegASPNET11\WroxUnited\admin\login.aspx:57
   ASP.login_aspx.LoginBtn_Click(Object Sender, EventArgs e) in C:\BegASPNET11\WroxUnited\admin\login.aspx:11
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +83
   System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

Sarah:

Are you using the VB version of the book? Then possibly the problem is that login.aspx is missing from the download? If you check and see that you don't actually have a login.aspx, you can get it from the C# book version download at:
http://www.wrox.com/WileyCDA/WroxTit...load_code.html

then just modify it for VB. I'm working on getting the VB version verified and added to the download.

If this isn't the problem, please let us know.



Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Jim's Book of the week: ASP.NET 2.0 Beta Preview

I'm using the C# version of the book, unfortunately, so that isn't the problem. I'm wondering--is there a problem with the code itself? My code matches the downloaded code so could it be in one of the associated files?