Uploading multiple images using one browse button(Ctrl+) &DB

Question

Hi,

I want complete code for uploading multiple images using one browse button and Database...i.e when i click on Browse button, i want to select multiple images ata time for uploading using Ctrl button...

Saritha A · Answer

Thanks Vishal....

Vishal Gilbile · Answer

Hi Sarita, Let's assume that your page name is Default.aspx and you want to implement this functionality in your Default.aspx page. Step 1: a. Add the necessary css folder to your application b. Add the necessary script folder to your application c. Add the necessary image folder to your application d. Add the imageUploade r .ashx File to your application These all things you will get from NewFolder2.rar file which i provided to you. Step 2: After you are done with the step 1, Add the following code in your default.aspx page head section var errorCount = 0, successCount = 0; $(document).ready(function () { $(function () { $('# file_upload ').uploadify({ 'swf': 'scripts/uploadify.swf', 'uploader': 'imageUploader.ashx', 'cancelImg': '/image//uploadify-cancel.png', 'fileExt': '*.jpg;*.jpeg;*.gif;*.png;*.ods;*.xlsx;', 'buttonText': 'Select Files', 'displayData': 'percentage', 'fileDesc': 'Image Files', 'multi': true, 'auto': true, 'sizeLimit': 5000000, 'queueSizeLimit': 10 }); }); }); If your Default.aspx page is a content page then add it with the following section //paste it over here. Step 3: The one highlighted with yellow color in your script code (" file_upload") needs to be you FileUpload Control's ID. Step 4: Now your task is just to verify the path of your imageUploader.ashx file and uploadify.swf and cancel Image file path what we have provided in script code. Step 5: Last step is to change the function what we wrote in imageUploader.ashx File with the name SaveFile. IF your using oracle DB there is no need to change this function but if you are using Sql then replace the function with the following code. private void SaveFile(byte[] rawBytes) { try { string dbCon = "Your Connection String over here"; SqlConnection con = new SqlConnection(dbCon); con.Open(); SqlTransaction trans = con.BeginTransaction(); SqlCommand cmd = new SqlCommand("Your Procedure Name", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter para = new SqlParameter(); para.ParameterName = " your procedure Variable name here "; para.DbType = DbType.Image; para.Value = rawBytes; para.Size = rawBytes.Length; cmd.Parameters.Add(para); cmd.Transaction = trans; cmd.ExecuteNonQuery(); trans = null; con.Close(); } catch (Exception e1) { throw e1; } } Hope that finally solves your problem. With Regards, Vishal Gilbile.

Saritha A · Answer

Thanks Vishal, But i don't know where i want to change...My database is sql server 2008..please let me know....

Vishal Gilbile · Answer

Hello Sarita, Kindly open the new folder2.rar file it will do the same the only thing is my DB was oracle you will have to change a little code in imageUploader.ashx file Save function using sql classes if your DB is sql. The above code will directly upload an image inside DB. Hope that solves your problem. Kindly mark the answer as accepted if its solves your issue. With Regards, Vishal Gilbile.

Saritha A · Answer

Hi vishal, Thanks for ur reply.....i want to apply multiple images at a time with one upload control and also using with Database...did u understand my question?

Vishal Gilbile · Answer

Hello Friend, I've made use of Jquery uploader attached is the code snippet for the same. Hope that solves your problem. With Regards, Vishal Gilbile.

Saritha A · Answer

Hi Satyapriya, Thanks for ur reply..here,u r using 10 browse buttons...suppose if i want upload 100 images,i will be using 100 browse buttons according to ur answer...but,my requirement is using 1 browse button i want to upload 100 images at a time.. Thanks,

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/uploadfile/prathore/multiple-image-upload-in-Asp-Net/ http://www.dotnetcurry.com/ShowArticle.aspx?ID=317

Ish Bandhu · Answer

Hi, please find code with attachment.

Uploading multiple images using one browse button(Ctrl+) &DB

Answers (9)