Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Categorizing results by letter

Status
Not open for further replies.
TheDust

TheDust

Programmer
Aug 12, 2002
217
US
I have been having trouble coming up with an effective way to take a list of values from a dataset and group them by letter on a page.

For example the page would start with a "#" heading and display all listings starting with a number, then below that an "A" heading with all listings starting with "A", and so on...

Can anyone reccomend a quick and efficient way of doing this, without hitting the database 27 times?

Thanks in advance to anyone who can lend a hand,
Dust
 
Status
Not open for further replies.

Similar threads

stinkybee
  • Locked
  • Question
Change order by in a selectcommand using parameters
Replies
1
Views
121
johnny9864
johnny9864
MrMode
  • Locked
  • Question
loop through CheckBoxList selected items and insert results into SQLdatabase 1
Replies
5
Views
234
jbenson001
jbenson001
rootl
  • Locked
  • Question
Search engine - need to display results on separate page
Replies
3
Views
77
jbenson001
jbenson001
sirnose1
  • Locked
  • Question
'The process cannot access the file because it is being used by another process' with FileUpload con
Replies
2
Views
103
sirnose1
sirnose1
tshad
  • Locked
  • Question
Bug in cmd.Parameters statement and byte?
Replies
8
Views
118
jbenson001
jbenson001

Part and Inventory Search

Sponsor

Back
Top