I have coded into my version of Wrox United the code found in pages 360 & 361 (also have checked it with the downloaded copy from Wrox Website which shows exactly the same error). The code supplies values for both dbCommand CommandText & Connection in the Function Dates, however the compiler says there are other requiredparameters and sticks at the line first after opening the connection? Can anyone tell me what these other parameters might be?

Note: The code in line 55 is divided in the book, I have it as a single line, if it appears split it is word wrap.

Server Error in '/WroxUnited1' Application.
--------------------------------------------------------------------------------

No value given for one or more required parameters.
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 53:
Line 54: dbConnection.Open()
Line 55: Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavio r.CloseConnection)
Line 56:
Line 57: Return dataReader


Source File: c:\inetpub\wwwroot\WroxUnited1\Default1.aspx.vb Line: 55