Replace blank images with default image

[amandab116]

In my program I am storing images in the database. Not all of the records in the database have images, and when I load the details into another .aspx page, sometimes the image is empty- has a red "x". How do I replace that "x" with a default image?

[Bassem]

I didn't get the code-problem so let me suggest another way to solve it.
It's not a perfect one but until you find the problem.
You may pass intImageSize as a parameter to myCommand and make your test for the NULL value in Sql as this :

@intImageSize   int
     if(@intImageSize = 0)
          @picture = null
 -- then the rest of your query ...

If it works so the problem was in passing the null value. If not make sure that you didn't set a default value for picture column. If you did remove it, It've to be null.

Actually I don't store images in database, I save images as files each has an identical name, by using an index for example, and storing only the path. Think about it, if the problem still annoying.

Thanks,
Bassem

[amandab116]

I've solved the problem by implemeting the code like you've suggested :)

Now I've run into the dilemma of trying to solve the issue of overwriting already supplied images.

If the upload box is left blank, it still updates the database as a null... overwriting anything that was already stored.

As you can see, this is my first time using images in my database. I can't store the filepath because this is a program allowing users to create new resources and upload a picture from their machine and it needs to be stored in the database itself, not just the filepath.

[Bassem]

You're inserting records, I see no updating?!
What's the primary key in this table and which columns are unique?
How do you checked that the date is overwritten? or how do you make the select query?

About storing paths of images,
You can save the image on a server directory and store paths refer to these images on server.

>> data not date <<