This thread is for discussions of Uploading Images to a Database.

Ok,

Im sorta new to ASP.Net and Ive got the image upload to blob working ...

But for this to be moreso practical, it would be nice to see the ability to upload into another field, the thumbnail automatically generated from the blob data. (or when it gets uploaded).

Can someone help or point me in the right direction?!?!

Im desperate

Hello,

I need some more idea on this topic. What is benifit to store data into SQL server (means into BLOB chartype in SQL). Why can not we just store file on to PC and just add link name into SQL.

Please can anybody give me this ans.

Thanks

i have been able to implement this and i now upload all sorts of documents including images into my sql server database. i now need to retrieve the document in the original format (.doc, .xls, .jpg, etc). pls, i do i achieve that?

Better control of file updates.  On file server, anybody can update files without letting anyone know about it.  If you store a file inside SQL database, it will show who last updated files, inform users when it expires, requiring updates and so on.  I administer 230 manual documents that shows original creator, date of implementation, maintainer and updated date.  Very useful and uniform in updates and maintenance.

The explanatory text says "The first interesting point about our webform, is the attribute "enctype". Enctype tells the browser and server that we will be uploading some type of binary data" but I don't see enctype in the code samples. Have I missed something?

Les

Hi,   Whts the benifit of uploading images in database server when i can place images on web server in my directory and accesss them. Reply soon.

The easiest way to upload and resize an image to the internet and automatically create thumbnails is I-Load.
I-Load is a FREE ASP.NET web control with numerous benefits and features.
You can download I-Load (it's FREE!) and view an online demo here:

http://www.radactive.com/en/Products/ILoad/Overview.aspx

This may sound weird but I think I'm the only one not having perfect success with this.

I'm getting a System.NullReferenceException: Object reference not set to an instance of an object.
on the line

Stream imgStream = UploadFile.PostedFile.InputStream;

[NullReferenceException: Object reference not set to an instance of an object.]
   DBImages.UploadImage.BtnUpload_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\official-certify\Media\SubmitJon.aspx.cs:70
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33

  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

I'm not sure why I'm getting this error. I copied the code verbatum and then added references for my other fields that I'm pulling in.

I have no idea what the stack trace is all about, like I understand stacks, but the way these are formatted makes no sense to me, although here's what's in it maybe you guys will know.

((my button is exactly the same just named BtnUpload as opposed to UploadBtn.))

If anyone could help it would be greatly appreciated. It's been driving me nuts I've run into a bunch of other errors that I've fixed, mostly missing a ";" but I've taken care of them all, this is the only one I haven't figured out yet (well unless there's more after this one is fixed) Thanks in advance for the help