i'm helping a friend and i'm almost done with the program what i can't figure out is i need to sort the number of votes from lowest to highest my database is just ms access and i'm trying to display the photos of the candidates who got the highest votes but i'm so lost here i hope somebody can guide me.
Jump to Post
Ok. If that's the case, there's no need retrieve the record(s) with the highest number of votes.
You could use a DataAdapter instead of DataReader for your
sqlcouncilquery (and select all fields, not just num_of_votes), place the result into a DataTable, and retrieve the first 8 rows.
All 11 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.