Updating SQL Server 2000 From ASP.net

I am really lost understanding using SQL Server 2000 with ASP.net Webb apps. If you are dong windows apps, the form builder wizard will either build you a page with a grid for displaying multiple records, or a single record page with text boxes.





All well and good.





With ASP.net web apps, though, you only get the option for making the gred/multiple record page.





So I try to make a page with textboxes to use to update my table in Sequel Server. I do my data binding, and fill my adapter, and viola, the data from my first row appears in the text boxes.





Here is the problem. I have a "Next" button and a "Previous" button that I want to use to move forward or backward through the rows in the table. What code do I put behind the buttons?





I created a windows app and used the dataform wizard to make a single record form. The code it puts behind the "Next" button is





Private Sub btnNavNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavNext.Click


Me.BindingContext(objDS_SclRcd, "IMA_School").Position = (Me.BindingContext(objDS_SclRcd, "IMA_School").Position + 1)


Me.objDS_SclRcd_PositionChanged()





End Sub





I tried to incorate the logic into my ASP web page, but can't figure out how to do it.





It seems like it ought to be simple, like position = position + position, but I can't figure it out.





Also, after I enter data changes, how do I save the updated data from the screen to the data set before moving on to the last record?





Last, how do I tell the dataset to go back and update the connextion server?








I really want to be able to update SQL data from a remote client usuing ASP web page, but none of my manual address how to do it.





Any help would be great.





Thanks





Jim