ASP.NET

1-Aug-06 19:56

How do i display image from a database on an ASP page.
being read in a stream. which component should i use.
doing so is possible in window based application

This Is the code

SqlCommand comm = new SqlCommand("select photo from photos where name='sachin'", conn);

byte[] b = (byte[])comm.ExecuteScalar();
if (b.Length > 0)
{
// Open a stream for the image and write the bytes into it
System.IO.MemoryStream stream = new System.IO.MemoryStream(b, true);
stream.Write(b, 0, b.Length);
//if c#'s window based application then i can do it like this
//pictureBox.Image = new Bitmap(stream);
}

Sarbjeet Singh

l0kke1-Aug-06 23:21

1-Aug-06 23:21

I'm affraid you have to save the image to your disk and then set ImageUrl property of System.Web.UI.WebControls.Image object to url of saved image.

Pilo

sabby20062-Aug-06 21:37

2-Aug-06 21:37

Do i have the permission to write on clients HDD.

probably i can write in temp folder which is inside Windows or Winnt folder.
how do i get the system folder's name i mean is it windows or winnt

Thanks

l0kke3-Aug-06 6:37

3-Aug-06 6:37

You can not write to a folder outside an application root. Imagine if users can display files from Windows folder... no no, that's bad idea Smile | :)

Just create folder Images in your application root (c:\inetpub\wwwroot\MyApp usually) and set permissions to write to this folder for user IUSR_MACHINENAME, where MACHINENAME is name of your computer. This user is account IIS is running under. Then you can assign this url to your Image control: "~/Images/mySavedImage.jpg"

Should be working, if not, write down what is wrong.

Pilo

sabby20063-Aug-06 22:43

3-Aug-06 22:43

i am reading the image from the database.
what will happen if three four users come at the same time.

Regards

l0kke4-Aug-06 9:45

4-Aug-06 9:45

Thats not a problem

sabby20063-Aug-06 23:37

3-Aug-06 23:37

its working!!!!!!!!!!!!

But dont knwow how it will behave when different users with same file name and same extension will visit at the same time.

Thanks AnyWays
If Some problem come up i will get back

Regards

l0kke4-Aug-06 9:47

4-Aug-06 9:47

U have to check if file with this name exist, and if so, just put number at end of the name:
myImage.jpg
myImage1.jpg

And you should have some mechanism to check how long files are there and delete them after some time...

Pilo

sabby20064-Aug-06 23:27

4-Aug-06 23:27

Thanks is't working

Regards

Ista2-Aug-06 3:57

Ista

2-Aug-06 3:57

Either do 3 things.

1) Have a aspx page that draws the picture
Set the content type to jpeg or whatever and load the binary values into it

2) Save the image to a local file so the image can be saved and set the path.

3) you might be able to just take the data create create a stream out of it. then apply it to an image object. But it prolbably won't work in the end

--------------------------------------------------------

1 line of code equals many bugs. So don't write any!!

My mad coder blog

sabby20062-Aug-06 21:40

2-Aug-06 21:40

do i hav ethe permission to write on clients machine.

how to get the name of system folder.

Sarbjeet Singh

Ista3-Aug-06 2:46

Ista

3-Aug-06 2:46

nope. If you could then viruses could easily be delivered to everyone. Thats why you cant.

Just create a local file ( it will place it in the windiws\temp web app folder. and reference it

you dont need to specify a path. just use the web root or something.

It might be easier to just have a page that displays as a jpeg since you dont have to save the file anywhere. But you also have to realize thats an extra request. But, its the easiest

--------------------------------------------------------

1 line of code equals many bugs. So don't write any!!

My mad coder blog

l0kke3-Aug-06 6:30

3-Aug-06 6:30

Heh, good idea with content type, I didn't think about it Wink | ;)

But it is useable only if you want to have single image on a page and nothing else, otherwise it wouldn't works, I suppose.

Pilo