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.SqlClient.SqlDataReader'

Any suggestions?

[Marina]

Yes - look up the documentation for the SqlDataReader class.

"L. Oborne" <none(at)none.ab> wrote in message
news:e%****************@TK2MSFTNGP10.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.SqlClient.SqlDataReader'

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.ExecuteReader(CommandBehavior.Default)

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.public.dotnet.framework.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.SqlClient.SqlDataReader'

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.SqlClient.SqlDataReader'

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_SPAM_4_MEyahoo.com> wrote in message
news:%2****************@TK2MSFTNGP09.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.SqlDataReader'

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_SPAM_4_MEyahoo.com> wrote in message
news:%2****************@TK2MSFTNGP09.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.SqlDataReader'

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