FileUpload saving data to SQL Server table

Sign in to leave a comment.

• FM

  Former member14y agoPosted Sep 30, 2012, 1:22 PM

  This is really nice article http://www.dotnetpools.com/Article/ArticleDetiail/?articleId=5&title=Fileupload%20Control%20In%20Asp.net
• BB

  bob bill14y agoPosted Sep 24, 2012, 1:19 AM

  Great article!
• BW

  Bls Wilson15y agoPosted Feb 22, 2011, 8:29 PM

  sir kindly tell me, how to upload video in database and retrieve it on page and download it whenever needed
  • 

    Micke Blomqvist15y agoPosted Feb 23, 2011, 3:59 AM

    Hi Wilson, The only thing you need to do is to extend the ContentTypes in the db.cs file with the different filetypes for media you want to upload. I've added: else if (f.IndexOf(".wmv") != -1) return "video/x-ms-wmv"; and uploaded a Windows Media Video file and that worked lika a charm! =) You could also add: video/mpeg, video/mp4, video/ogg, video/quicktime etc. to cover what you need. Good luck!
• RK

  Ravi K Kashyap15y agoeditedPosted Feb 11, 2011, 12:19 AMEdited Feb 11, 2011, 12:20 AM

  Hi Micke, Nice Article :), I was just wondering about what would be the Content type of the upload file if i change the file extension? (i.e. if i change .exe to txt) By the logic as you have mention in the ContentType() method, it will always come as text\plain and will get saved to the DB which is not correct. I am also looking for the solution for this case, but a bit unsuccesfully till date... Hope i will get the solution today :) ..... Thanks,
  • 

    Micke Blomqvist15y agoeditedPosted Feb 11, 2011, 1:49 AMEdited Feb 11, 2011, 1:51 AM

    Hi Ravi, Thank you for your reply! Did you get text/plain for all your different uploaded files? I've run the app and uploaded both PDF's and GIF's and that runs well. If you add the following code snippet to the ContentType(string FileName) method, you'll be able to upload/response exe-files, as well. They will come with the "run/save/cancel" dialog for the end user. else if (f.IndexOf(".exe") != -1) return "image/octet-stream"; I hope that was that useful for you, Ravi!
• 

  Sivaraman Dhamodaran15y agoPosted Feb 10, 2011, 11:01 PM

  Nice Article Micke. Thanks for sharing it.
• 

  Manish Dwivedi15y agoPosted Feb 10, 2011, 10:52 PM

  Micke very informative article, Keep it up.
• 

  Mahesh Chand15y agoPosted Feb 10, 2011, 6:01 PM

  Thanks for sharing.