Click here to Skip to main content
14,269,736 members
Rate this:
Please Sign up or sign in to vote.
See more:
How to fetch records and display photo on the web page from table name USER of USER.MDB whose point is greatest from all record points?

My table's columns are


1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Have a look at this: A generic Image-From-DB class for ASP.NET[^] - it doesn't do the "greatest points" bit, but that is just a case of:
SELECT * FROM MyTable WHERE point=(SELECT MAX(point) FROM MyTable)
Janardan Pandey 24-Jan-12 3:43am
SQL is ok but i am not cleared by coad.Because i want to fetch and display image during page load event.
OriginalGriff 24-Jan-12 3:45am
Yes. Read the link - you will need to change it a bit, but it will work.
Janardan Pandey 24-Jan-12 3:57am
But this link is not clearly telling about this needfull work.Eloborate it.
OriginalGriff 24-Jan-12 4:15am
Are you taking the piss?
You are supposed to be a programmer - it is pretty much just a case of replacing a SELECT command...and there is only one of them in the whole link!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100