Do While Loop (ASP.NET) not working

[L. Oborne]

I have this code working fine in Classic ASP but I get compile errors when I
try to run it as ASP.NET.

Do While NOT RS.EOF
If ...
Then...
Else...
End If
RS.MoveNext
Loop

It says that 'MoveNext' is not a member of
'System.Data.Sq lClient.SqlData Reader'

Any suggestions?

[Marina]

Yes - look up the documentation for the SqlDataReader class.

"L. Oborne" <none(at)none.a b> wrote in message
news:e%******** ********@TK2MSF TNGP10.phx.gbl. ..

I have this code working fine in Classic ASP but I get compile errors when I try to run it as ASP.NET.

Do While NOT RS.EOF
If ...
Then...
Else...
End If
RS.MoveNext
Loop

It says that 'MoveNext' is not a member of
'System.Data.Sq lClient.SqlData Reader'

Any suggestions?

[Kyril Magnos]

That is correct. You are thinking in old ASP ways, not ADO.NET

The correct way to do it would be:
(Forgive my VB.NET, wayyyy rusty!)

<pseudo-code>
Dim reader As SqlDataReader =
SqlCommand.Exec uteReader(Comma ndBehavior.Defa ult)

Do While reader.Read()
If...
Then...
Else...
End If...
Loop
reader.Close()

HTH,

Kyril
-----Original Message-----
From: L. Oborne [mailto:none(at) none.ab]
Posted At: Wednesday, July 14, 2004 10:17 AM
Posted To: microsoft.publi c.dotnet.framew ork.aspnet
Conversation: Do While Loop (ASP.NET) not working
Subject: Do While Loop (ASP.NET) not working

I have this code working fine in Classic ASP but I get compile errors
when I
try to run it as ASP.NET.

Do While NOT RS.EOF
If ...
Then...
Else...
End If
RS.MoveNext
Loop

It says that 'MoveNext' is not a member of
'System.Data.Sq lClient.SqlData Reader'

Any suggestions?

[Craig Deelsnyder]

L. Oborne wrote:

I have this code working fine in Classic ASP but I get compile errors when I
try to run it as ASP.NET.

Do While NOT RS.EOF
If ...
Then...
Else...
End If
RS.MoveNext
Loop

It says that 'MoveNext' is not a member of
'System.Data.Sq lClient.SqlData Reader'

Any suggestions?

Use .NextResult instead

http://msdn.microsoft.com/library/de...mberstopic.asp

note these are new 'structures' in ADO.NET (which replaced ADO); the
reader is basically like the old connected recordset, but there are
changes....

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

[L. Oborne]

Great, Thanks!

Also, is there a replacement for 'If Not RS.EOF Then' ?
..NET does not like 'EOF'
"Craig Deelsnyder" <cdeelsny@NO_SP AM_4_MEyahoo.co m> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

L. Oborne wrote:

I have this code working fine in Classic ASP but I get compile errors when I try to run it as ASP.NET.

Do While NOT RS.EOF
If ...
Then...
Else...
End If
RS.MoveNext
Loop

It says that 'MoveNext' is not a member of
'System.Data.Sq lClient.SqlData Reader'

Any suggestions?

Use .NextResult instead

http://msdn.microsoft.com/library/de...mberstopic.asp
note these are new 'structures' in ADO.NET (which replaced ADO); the
reader is basically like the old connected recordset, but there are
changes....

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

[Craig Deelsnyder]

L. Oborne wrote:

Great, Thanks!

Also, is there a replacement for 'If Not RS.EOF Then' ?
.NET does not like 'EOF'
"Craig Deelsnyder" <cdeelsny@NO_SP AM_4_MEyahoo.co m> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

L. Oborne wrote:

I have this code working fine in Classic ASP but I get compile errors
when I
try to run it as ASP.NET.

Do While NOT RS.EOF
If ...
Then...
Else...
End If
RS.MoveNext
Loop

It says that 'MoveNext' is not a member of
'System.Data .SqlClient.SqlD ataReader'

Any suggestions?

Use .NextResult instead

http://msdn.microsoft.com/library/de...mberstopic.asp

note these are new 'structures' in ADO.NET (which replaced ADO); the
reader is basically like the old connected recordset, but there are
changes....

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

Actually, I think you want the .Read() method that returns a boolean, I
gave you a different method:

http://msdn.microsoft.com/library/de...sreadtopic.asp

please see the documentation.

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET