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

name
address
photo
point
Posted

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)
   
Comments
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