By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,268 Members | 1,293 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,268 IT Pros & Developers. It's quick & easy.

Next / Previous form to display records performance

P: n/a
vs 2002 - vb - access 2002 - xp - web forms

I want to display records, one at a time.
I have about 25 fields to display.
I've created SQL and retrieved records.
I placed data in 25 separate dropdown list. (made them invisible on form)
each time they pick next I add 1 and do something like this for each field
CurrentRecord += 1
(test for upper bounds and less then 0)
ddName.selectedindex = CurrentRecord
labelName.text = ddName.selecteditem.text

(repeat 25 times for each field)

Very slow to display page.

which is best
the above
or
Stuffing all data into session variables
or
retrieve the entire list from DB each time. and just keep CurrentRecord in
session variable.

Thanks
Tony
Nov 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.