Image Loading from SQL Server into ASP.NET

[Guest]

Hi,
I have employee details stored in SQL DB includes emp id , name, age, sex
and photo (stored as image binary format).

Now in text box I am entering empid and click of a button I want to get all
the details into a aspx page

Name XXXXX
Age YY
Sex ZZ
Photo Photo should be displayed here

Please advise me how can I do this, all the other data I can populate but
how I will load employee photo. Photo should be displayed in the same page.

Thanks in advance

 

[Guest]

Here is one way to do this:
http://www.eggheadcafe.com/articles/20050911.asp
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder(BETA): http://www.blogmetafinder.com

 

[Guest]

Hello,

You have two possiblities:

- Store the images in a folder of your website and store the link to
them in a field of your database (easy solution, and you don't have to fight
against performance problems storing blobs in your DB).

- You can phisically store it in your DB, take a look at this article:

http://www.ftponline.com/vsm/2002_07/online/hottips/esposito/

HTH
Braulio
/// ------------------------------
/// Braulio Díez
///
/// http://www.tipsdotnet.com
/// ------------------------------

 

[sloan]

Here is another caveat on the issue:

http://groups.google.com/group/micr...64932a17be1/38ef1b1401c5b53a#38ef1b1401c5b53a

from Jeff Prosise.

However, your "bulk solution" (for multiple images in a grid/bound control)
was good reading material as well.