For C# developers. C# - Upload Multiple Files with Thumbnail, Folders, and SQL Server Database«
UPDATE = 12/31/2022
I found an issue with the code while working on our Music site; once I fixed the issue on the site, I updated the code here. So now it will work with network and local folders.
Live Lessons Example - VB.NET - Upload Multiple Files with Thumbnail, Folders, and SQL Server Database
In 2011, I created the Uploadify VB.NET script for uploading multiple files to a specified folder listed in the code. However, the Uploadify Flash component was no longer supported in major browsers, so I had to look for an alternative for our websites and future projects.
I came across one that I liked but could not get to work on the IIS web server. So, after not coming up with any other alternatives, I took the advice of a fellow programmer, David, on the website Experts Exchange«. David suggested I create my own, so I would have complete control over what it does and ensure it worked in IIS, and that is what I did.
Instead of reinventing the wheel, I searched for a premade JQuery multiple upload script with thumbnails for ASP.NET. I did not care if it supported VB.NET, as I could quickly convert it over to VB using the online conversion tool Telerik.«.
After a quick 2-minute search, I found a thread on aspsnippets.com« which did precisely what I needed.
The code only uploads files to a designated folder, so I had to handle the rest myself. I started hammering away at the code to make it do what I needed.
In the script below, you will find everything you need to make it work straight from the box. An instructional video will also be available on the site when it goes live to help you with any issues you may encounter along the way.
    What this script does.
  1. Written in VB.NET, this upload script is very robust, allowing you to upload many files. Easily changed in the web.config file and the JS script.
  2. Page checks if there is a QueryString("ID") available. If not, a warning is given with a link to click. The button on the page is disabled until a valid ID is present. You can expand on this to include a database check to ensure the user who uploads the images has a valid ID and is logged in to their account before everything is set up and available.
  3. If the file is larger than the set file size, it will show an error, and the file will not be available for uploading.
  4. Create two folders, Big and Thumbs, with the ability to add more folders easily within the aspx.vb file and within the web.config file.
  5. Images are resized using the resizeImage() function. Images are not only smaller in diameter but also in pixel size.
  6. Information inserted into SQL Server Database. (Included Table Script)
The database table information is listed here.
    Table name: ImageServer
  1. [PicsID][int] IDENTITY(1,1) NOT NULL,
  2. [PicsFolder][nvarchar](50) NULL,
  3. [Userid][int] NULL,
  4. [DefaultFolder][int] NULL,
  5. [PicsPath][varchar](255) NULL,
  6. [PicsName][nvarchar](50) NULL,
  7. [PicsSize][int] NULL,
  8. [PicWH][varchar](50) NULL,
  9. [PicDate][datetime] NULL,
  10. [DateUpdated][datetime] NULL,