Hi!
I am trying to create a DataReader in .Net 2003, retrieving data from an
Access backend db. In the code below, when I put a breakpoint within
the While...Read() loop, the datareader returns five records (which is
correct). However, when I simply run the program without the
breakpoint, only one record is being returned. Is there something I'm
missing???? The connection state is "Open", so I'm not sure why all
records aren't being returned.
Dim intUpdateEMGsCo unt As Integer = 0
Dim cnnUpdateEMGs As OleDbConnection = New
OleDbConnection (IMUX_Globals.c onnBE.Connectio nString)
Dim cmdUpdateEMGs As OleDbCommand = New OleDbCommand("S ELECT " & _
"lngEMGId, " &
_
"IIf(IsNull ([CountETB]),0, [CountETB]) AS TotalETB, " & _
"IIf(IsNull ([CountEMRPS]),0, [CountEMRPS]) AS TotalEMRPS, " & _
"IIf(IsNull ([CountRTT]),0, [CountRTT]) AS TotalRTT, " & _
"IIf(IsNull ([CountDCH]),0, [CountDCH]) AS TotalDCH " & _
"FROM " & _
"(((tblOrig _EMG
LEFT JOIN qgrpCountETB ON tblOrig_EMG.str EMG = qgrpCountETB.st rEMG) LEFT
JOIN qgrpCountDCH ON tblOrig_EMG.str EMG = qgrpCountDCH.st rEMG) LEFT JOIN
qgrpCountEMRPS ON tblOrig_EMG.str EMG = qgrpCountEMRPS. strEMG) LEFT JOIN
qgrpCountRTT ON tblOrig_EMG.str EMG = qgrpCountRTT.st rEMG", _
cnnUpdateEMGs)
cnnUpdateEMGs.O pen()
odrUpdateEMGs =
cmdUpdateEMGs.E xecuteReader(Co mmandBehavior.C loseConnection)
Console.WriteLi ne("State: " & cnnUpdateEMGs.S tate.ToString)
If odrUpdateEMGs.H asRows Then
While odrUpdateEMGs.R ead()
intNumRecs += 1
End While
End If
odrUpdateEMGs.C lose()
Console.WriteLi ne("Num Records: " & intNumRecs.ToSt ring)
TIA,
DaveS
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
