New to VB.NET problem w/ select count(*)

[bbwrede]

Hi,
I just started working w/ VB.NET and I am trying to run a query to select count(*). I am using access and have tried the query out on the dbase and get the correct results.

My problem comes in when I try to access the field from VB.NET.

CReader = Quart.ExecuteReader()
TotalReporting(2) = CReader.Item(0)

I always get the following error:
System.InvalidOperationException: No data exists for the row/column.


I have tried Creader.GetValue(0), GetInt16(0). I have also tried aliasing the count(*) as count1 and trying to access it that way.

What am I doing wrong.

Any help is greatly appreciated.
Thanks,
Barb

 

[bbwrede]

I figured it out. Thanks anyway!

 

[Custom24]

If you figure something out, post the solution

i'm guessing you either did a CReader.read before trying to read the data or you discovered the ExecuteScalar method of the Command object.



Mark