navigate through sql records [RESOLVED]

[drpcken]

Have a problem and can't put my finger on how to get it to work.

I'm making a webform, in the webform there are textbox controls. I'll use 3 for this example.

txtFirstName
txtMI
txtLastName

I also have a SQL table, (connections already created and working) where i have 3 columns: FirstName, MI, LastName. They also have a primary key called RecId which is just an autonumber.

I have 2 buttons: btnPrev and btnNext. See where I'm going with this? I want to click btnNext and have it put the values of the three columns in sql into the corrosponding 3 textboxes, and when I hit btnNext again, go to the next record, and so forth. When I hit btnPrev i want it to move to the previous record in the database.

I'm thinking I need to create a dataset holding this information, but getting it from the dataset to the txtboxes is stumping me.

PLEASE HELP!!! Thank you guys so much!!