Image Loading from SQL Server into ASP.NET

[=?Utf-8?B?VW1lc2huYXRo?=]

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

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

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

"Umeshnath" wrote:

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

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

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...tips/esposito/

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


"Umeshnath" wrote:

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

[sloan]

Here is another caveat on the issue:

http://groups.google.com/group/micro...ef1b1401c5b53a

from Jeff Prosise.

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

"Peter Bromberg [C# MVP]" <pb*******@yahoo.yabbadabbadoo.comwrote in
message news:D4**********************************@microsof t.com...

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

"Umeshnath" wrote:

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