Navigation

[NeoBushidaro]

In VisualBasic.net windows app I had a form that would allow you to look at one record at a time. Data was bound to textboxes and comboboxes. My boss would like this changed over to a VB web form

Here is the problem

after binding the filling the dataset and binding the appropriate field to each textbox it properly produces the first row in the database

but when I tried to create navigation buttons to move first/previous/next/last I copied and pasted from the VB windows form to the web form the following line stopped being valid

bindingcontext(<dataset obj>, <table name>).position

How would I have to modify this in order to accomplish this task? so that I could bidirectionly traverse the dataset

[Ecniv]

If you didn't bind them you could hold a recordset open, and using ADO and ASP you should be able to open a recordset then close the connection which leaves the user with a view of the data.

I have never tried it myself, but it should work. then your navigation buttons refer to the recordset you returned and do the usual forward and backward movements (next and previous).

I don't know if this method would mean less network traffic too - worth experimenting with.


Otherwise you need to use MoveNext and MovePrevious on the bound access under the buttons.


Vince