Thanks for your replies. Basically I am converting an ASP website
written in VB Script to ASP.NET with C#. Being my first project in
either ASP.NET or C#, I'm not very good with the terminology yet...when
I said recordset I meant the .NET equivalent!
The code that I was looking at that I thought might be a problem
converting was this :
Do While strNewStatus = "0" Or _
strNewStatus = "1"
rsTransaction.Close
Set rsTransaction = CreateObject("ADODB.Recordset")
rsTransaction.Open strTransaction & Session("SessionID") & "AND ID =
" & Session("ID"), connSession, adOpenStatic, _
adLockReadOnly, adCmdText
If Not rsTransaction.EOF Then strNewStatus =
rsTransaction.Fields("Status").Value
If timer() - StartTime >= 60 Then Exit Do
Loop
A VB6 application is running in the background which may or may not
change the strNewStatus value from it's default of 0 in the database on
the same machine. Therefore, I need some way of exiting the loop in
case this value does not change.
I have so far done a bit of work using data readers, and I don't forsee
having any problems with the data access side of things, although I
thought that I would have a problem with the timer side. Jon's reply
definitely worth looking into, though if you know of a better way to go
about this, then let me know.
Thanks for your time,
Mike
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!