How do I upload photo to sql database using Asp.net MVC

Question

I'm quite new to asp.net MVC. I'm following the NerdDinner tutorial and have created an Edit page to modify the dinner information. This time, I want to somehow have a photo uploaded and save to the database when I press the Save button.

So how can I do this?

If possible, can anyone point me to a good tutorial that shows me how to upload photos and store it into my sql database?

marcind · Accepted Answer · 2010-07-17 03:24:49Z

2

I'm not familiar with any tutorials, but here are the general steps you would need to take:

Modify your database and add a byte array column to your table
Update your ORM model (depending on which version of NerdDinner you are using it might be LINQ to SQL or Entity Framework)
Modify your edit view to include a <input type="file"/> tag
In your POST action method read the file bytes from the request and store them in the database (this post can get you started: http://www.hanselman.com/blog/ABackToBasicsCaseStudyImplementingHTTPFileUploadWithASPNETMVCIncludingTestsAndMocks.aspx)

answered Jul 17, 2010 at 3:24

marcind

53.2k13 gold badges129 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ubiquitous Over a year ago

Thanks for that. I had a look on the link you gave me. I have an error though on this part.... HttpPostedFile hpf = Request.Files[file] as HttpPostedFile; Cannot convert type 'System.Web.HttpPostedFileBase' to 'System.Web.HttpPostedFile' via a reference conversion, boxing conversion, unboxing conversion, wrapping conversion, or null type conversion How can I fix this?

Collectives™ on Stack Overflow

How do I upload photo to sql database using Asp.net MVC

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related