How to upload multiple images at once in DB by using Asp.net

Bilawal Niaz

9y1.4k.NET

PageCode:

Backend Code:

protected void Button1_Click(object sender, EventArgs e)

{

BSL.Image obj = new BSL.Image();

obj.Image1 = FileUpload1.FileName;

obj.Image2 = FileUpload1.FileName;

obj.Image3 = FileUpload1.FileName;

obj.Image4 = FileUpload1.FileName;

obj.Image5 = FileUpload1.FileName;

Random r = new Random();

long s = r.Next(10000, 200000);

obj.Image1 = s + FileUpload1.FileName;

obj.Image2 = s + FileUpload1.FileName;

obj.Image3 = s + FileUpload1.FileName;

obj.Image4 = s + FileUpload1.FileName;

obj.Image5 = s + FileUpload1.FileName;

string path = Server.MapPath(@"Images/New/" + s + FileUpload1.FileName);

FileUpload1.SaveAs(path);

PictureHandler obj2 = new PictureHandler();

obj2.AddImage(obj);

}

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradeep Sahoo9y ago
follow this

http://www.c-sharpcorner.com/uploadfile/prathore/multiple-image-upload-in-asp-net/
Manas Mohapatra9y ago
Try like below :
<input type="file" multiple="multiple" name="FileUpload1" id="FileUpload1" />
<asp:Button runat="server" ID="uploadedFile" Text="Upload" OnClick="uploadFile_Click" />
Code-behind
protected void uploadFile_Click(object sender, EventArgs e)
{
   if (UploadImages.HasFiles)
   {
       foreach (HttpPostedFile uploadedFile in UploadImages.PostedFiles)
       {
           uploadedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Images/"),
           uploadedFile.FileName)); listofuploadedfiles.Text += String.Format("{0}", uploadedFile.FileName);
       }
   }
}
Salman Beg9y ago
In your Web.config set like this and change connectionString as like your database

thanks.

Bilawal Niaz9y ago

I applied this link that you refer me.

I follow the same steps, but they show eror:

Object reference not set to an instance of an object.

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

Salman Beg9y ago
plz follow this article,
http://www.aspsnippets.com/Articles/Upload-and-save-insert-multiple-files-to-database-in-ASPNet-using-C-and-VBNet.aspx
thanks
Bilawal Niaz9y ago
brother this link show that, can store only one image at a time.
but i want that db will store multiple images at once time.
when i click the button multiple image will be stored on data base.
can you help me for this problem?
Salman Beg9y ago
Hi.
First thing i never advised anyone to store the images in db and used it. rather than that we can store that image in a folder and in db i can store the path of it and used it. But as you are using to save in db so you can call it in a loop otherwise keep all the images in a datatable and update the database at one time.
while adding the images in db then at that time you need to get byte[] of each image and need to save it.Please follow this article,
http://www.aspsnippets.com/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx
thanks.
Bilawal Niaz9y ago
plz help me

the error is that when i save more than 1 pic,
first picture will be save on whole table
e.g;
Image1 =1.jpg
Image2 =1.jpg
Image3 =1.jpg
Image4 =1.jpg
Image5 =1.jpg
Bilawal Niaz9y ago
here is my source code and data base
Nitin Sontakke9y ago
In my strictly personal opinion, you are better of making several calls in a loop.

Having said that, what is the business requirement, if any, of sending all the images at once?
Bilawal Niaz9y ago
idon't understand your answer
Tus T9y ago
use user defined table type of sql whenever insert multiple row in database.