I have a problem with this exercise - an error occurs on the following line:
By experimentation I found that if I swapped this line and the following one (goalsAgainst += etc), the error occurred on this line instead. Also if I set a breakpoint on this line and then step through the code, the error occurs after a number of times through the While loop, so I conclude that it's a particular match in the Fixtures table that causes a problem, rather than something to do with the code itself.

Here is the error text:

(rest of detail omitted)

I loaded the "End" version of Chapter09 in VWD, and Decisions.aspx ran in the browser without a problem, so I compared the two pages from the "Begin" & "End" folders.

The "End" version is using a PageInitComplete event instead of PageLoad. I can't spot any other differences. However, if I simply change the event in the "Begin" version, it still doesn't work.

If it helps, I will post the code but if you have the book, it's on p325.

Richard
Rugeley, UK
WinXP Pro SP2
VBW Express + SQL Server 2005 Express

__________________
Richard
Rugeley, UK
WinXP Pro SP2
VBW Express + SQL Server 2005 Express

Some progress. I opened the Fixtures table in VWD Database Explorer and found that the last record contained NULL for the goalsFor & goalsAgainst values. Using the breakpoint, I confirmed that this was the point were the error occurred, so I changed the values to numeric and re-ran the Debugger. Hey Presto! The result is displayed in the browser without errors.

Has anyone else encountered this issue? Does your Chapter09 Begin copy of WroxUnited.mdf contain Nulls in the Fixtures table?

Richard
Rugeley, UK
WinXP Pro SP2
VBW Express + SQL Server 2005 Express

Surprise, surprise - the database in the End folder for Chapter09 doesn't contain Nulls in the affected fields.

Richard
Rugeley, UK
WinXP Pro SP2
VBW Express + SQL Server 2005 Express