Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Looping process with datareader
Message
From
14/07/2004 12:15:31
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Looping process with datareader
Miscellaneous
Thread ID:
00924270
Message ID:
00924270
Views:
51
Dear The Expert,
I don't understand .. why my looping process below (with level break condition) does not working ..I meant the "mTotalFreq" always has incorrect value.. it seems like the looping process has skipped one or some records, am I missing something?

DataReader = Cmd.ExecuteReader
While DataReader.Read
mHostCode = DataReader("HostCode")
While DataReader.Read = True And DataReader"HostCode") = mHostCode
mTotalFreq = mTotalFreq + DataReader("TotalCost")
End While
End While
DataReader.Close()
SQLTemp.Close()

I need advise .. many thanks in advance

Regards
Winanjaya
Next
Reply
Map
View

Click here to load this message in the networking platform