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.

 

[kiransolkar]

Use Image handler to call a Image From database
call ur image in Image1 redirect it using querystring
call ur Image by a Primary Key into using ID;

Image1.ImageUrl = "~/MyPhoto.ashx?Id=" + TextBox1.Text;

"MyPhoto.ashx" is a Image Handler

public class MyPhoto : IHttpHandler
{
public void ProcessRequest(HttpContext context)
{
string id = context.Request.QueryString["Id"];
context.Response.ContentType = "image/jpeg";
Stream strm = ShowEmpImage(id);
byte[] buffer = new byte[4096];
int byteSeq = strm.Read(buffer, 0, 4096);
while (byteSeq > 0)
{
context.Response.OutputStream.Write(buffer, 0, byteSeq);
byteSeq = strm.Read(buffer, 0, 4096);
}
}

public Stream ShowEmpImage(string id)
{
DataClassesDataContext context1 = new DataClassesDataContext();
var r = (from a in context1.ImageTables where a.Id == id select a).SingleOrDefault();
return new MemoryStream(r.FileSource.ToArray());
}
public bool IsReusable
{
get
{
return false;
}
}
}