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?

 

[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?

 

[trint]

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