ADO record set rs.MoveNext only works once...help

[trint]

Ok,
MoveNext is only moving to the next record once, then it stays on that
record unless I use these (which work just fine) MoveLast MoveFirst
MovePrevious.

private void btnNext_Click(object sender, System.EventArgs e)
{
ErrorLabel.Text = (rs.RecordCount.ToString());
// this code is used to prevent going to EOF
if(rs.RecordCount != 1)
{
if (!rs.EOF)
{
rs.MoveNext();
if (rs.EOF)
{
rs.MovePrevious();
}
PopulateSimpleNavigationForm();
}
}

Is it screwy because it is a WebApp? I can make a WinApp work just
fine with the same code.

Any help is sincerely appreciated.
Thanks,
Trint

[Miha Markic [MVP C#]]

The big question is, why don't you use ado.net?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"trint" <tr***********@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Ok,
MoveNext is only moving to the next record once, then it stays on that
record unless I use these (which work just fine) MoveLast MoveFirst
MovePrevious.

private void btnNext_Click(object sender, System.EventArgs e)
{
ErrorLabel.Text = (rs.RecordCount.ToString());
// this code is used to prevent going to EOF
if(rs.RecordCount != 1)
{
if (!rs.EOF)
{
rs.MoveNext();
if (rs.EOF)
{
rs.MovePrevious();
}
PopulateSimpleNavigationForm();
}
}

Is it screwy because it is a WebApp? I can make a WinApp work just
fine with the same code.

Any help is sincerely appreciated.
Thanks,
Trint

[Bill Gregg]

I only see you using rs.MoveNext once. Did you mean to have

While (!rs.EOF)
instead of

If (!rs.EOF)
?
If you call rs.MoveNext one time, it's going to move 1 time. If you
want it to keep going, you need to keep calling it. Am I missing
something?

*** Sent via Developersdex http://www.developersdex.com ***

[trint]

I fixed it by changing back over (entirely to ado.net).
Thanks everyone.