I typed in the following code according to the example on Page 104:

Dim objDataReader As OleDbDataReader
...
If objDataREader.HasRows Then
...

   I get an error on .HasRows: "'HasRows' in not a member of 'System.Data.OleDb.OleDbDataReader'."

   This is the second example in the book I can't get to work using the code as printed in the book.

Please help. Is there Errata? What can I check to fix this?



mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Another reader had a similar problem and was using Visual Studio 2002 as I expect you are. All of the code in the book was written using Visual Studio 2003.

However, to resolve this problem, all you need to do is to remove the If statement that checks the HasRows property of the DataReader.

Thearon

I am indeed using Microsoft Development Environment 2002. I wil have to upgrade. I only have VB.Net installed. Can I upgrade just the VB, or do I need the entire studio?

Also, how would I remove the If statement? Just rem out all the lines between If...End If? Or remove the conditional part, and leave the While...End While? I believe it is the latter. I am assuming this is okay to do since we know that conditional for purposes of this example?

mmcdonal

I remmed out the If line and the End If closing line, and it worked as advertised.

I will follow your upgrade advice when posted.

Thanks again for the help.

mmcdonal

mmcdonal,

There's no need to upgrade as I believe that is possibly the only feature in the code that is not in Visual Studio 2002. If everything else is working fine as is then continue on with the exercises.

Of course if you want to upgrade then consult the Microsoft web site for the appropriate options at http://msdn.microsoft.com/vstudio/.

Thearon