I did the similar thing couple years ago, storing images in database.... i thought it was a good idea but my senior told me not to do so with some reason i my self forgot what the exact his argument was....... kind of overhead... storing images into database may reduce the performance of that database engine itself..then i saw article telling the same, it was on 4guysfromrolla i think.
Now i store all images in a secured folder and create a handler to access that images indirectly. so the html would display like this : <img src="~/handlers/photo.ashx?id=424"> id 424 is referring to primary key on the table where the image is residing...... and the handler will pick up the filename from that table, read that file and send it back to the browser as byte of array. On Wed, Sep 29, 2010 at 10:46 PM, Processor Devil <[email protected] > wrote: > Storing image in database record is a very bad practice when you have very > limited database space.... Sharing image as external link is a very bad > practice when you have very limited web hosting. > Arguing on the internet is like running in Special Olympics... Even if you > win, you are still retarded :). > > 2010/9/29 Jamie Fraser <[email protected]> > > Sorry, what? Care to share why its bad practice? >> >> >> On Tue, Sep 28, 2010 at 11:46 PM, Gunawan Hadikusumo < >> [email protected]> wrote: >> >>> you wanna save the image on the server ? bad practice ,mate ...not >>> recommeded.... >>> >>> >>> On Wed, Sep 29, 2010 at 1:43 AM, Stephen Russell <[email protected] >>> > wrote: >>> >>>> On Tue, Sep 28, 2010 at 10:33 AM, Ronak <[email protected]> wrote: >>>> > Hii >>>> > >>>> > I have a big trouble in saving image in sql server. >>>> > >>>> > Actually I have ms access file and in that I have ole object field in >>>> > which I have stored >>>> > a photograph and I want to save that photograph in sql server using >>>> > asp.net. >>>> > >>>> > I have got the data in datatable but dont know the data type to pass >>>> > in parameter. >>>> > >>>> > I dont know how to do, >>>> > >>>> ------------ >>>> >>>> Lots of examples here: >>>> http://lmgtfy.com/?q=saving+image+in+sql+server >>>> >>>> >>>> >>>> >>>> -- >>>> Stephen Russell >>>> >>>> Sr. Production Systems Programmer >>>> CIMSgts >>>> >>>> 901.246-0159 cell >>>> >>> >>> >>> >>> -- >>> johnhadikusumo.blogspot.com >>> www.miniadverts.com.au >>> >>> >> > -- johnhadikusumo.blogspot.com www.miniadverts.com.au
