How to Upload Selected Multiple Images into the Database

Question

I need to Upload Image selected in the Website into the DB My project has multiple File Select "File Upload" how can I Upload those multiple Files into Database the Image data in Binary Format, My Code is

    protected void Button1_Click(object sender, EventArgs e)

   {

        string Qry = "insert into tblFiles values(@data)";
        SqlConnection con = new SqlConnection(@"Data Source=ESLHPC17\SQL2008;Initial Catalog=dbFiles;User ID=user;Password=password");

        SqlCommand cmd = new SqlCommand(Qry,con);
        cmd.Parameters.Add("@data") = FileUpload1.FileBytes;

    }

I am using the Following Web Handler to Save the Files in local Folder

<%@ WebHandler Language="C#" Class="Upload" %>

using System;
using System.Web;
using System.IO;


public class Upload : IHttpHandler {

public void ProcessRequest (HttpContext context) {
    context.Response.ContentType = "text/plain";
    context.Response.Expires = -1;
    try
    {
        HttpPostedFile postedFile = context.Request.Files["Filedata"];

        string savepath = "";
        string tempPath = "";
        tempPath = System.Configuration.ConfigurationManager.AppSettings["FolderPath"]; 
        savepath = context.Server.MapPath(tempPath);
        string filename = postedFile.FileName;
        if (!Directory.Exists(savepath))
            Directory.CreateDirectory(savepath);

        postedFile.SaveAs(savepath + @"\" + filename);
        context.Response.Write(tempPath + "/" + filename);
        context.Response.StatusCode = 200;
    }
    catch (Exception ex)
    {
        context.Response.Write("Error: " + ex.Message);
    }
}

public bool IsReusable {
    get {
        return false;
    }
}

}

and I use the below Script

 <script type = "text/javascript">
      $(window).load(
function () {
    $("#<%=FileUpload1.ClientID%>").fileUpload({
        'uploader': 'scripts/uploader.swf',
        'cancelImg': 'images/cancel.png',
        'buttonText': 'Browse Files',
        'script': 'Upload.ashx',
        'folder': 'Uploads',
        'fileDesc': 'Image Files',
        'fileExt': '*.jpg;*.jpeg;*.gif;*.png',
        'multi': true,
        'auto': false
    });

but I want to store the Images in Database

@ Damith

I have tried in with the below mentioned code but it didn't worked,

   protected void Button1_Click(object sender, EventArgs e)
    {
        string FolderPath=@"E:\Rajesh_Kumar\Application\Valuation\ExamManagement\ExamManagement\Uploads";
        string path = System.Configuration.ConfigurationManager.AppSettings[FolderPath];
        string Qry = "insert into tblFiles values(@data) Values (data)";
        SqlConnection con = new SqlConnection(@"Data Source=ESLHPC17\SQL2008;Initial Catalog=dbFiles;User ID=rajesh";
        StreamReader sr = new StreamReader(path);
        while (sr.ReadLine() != null)
        {

                using (SqlCommand cmd = new SqlCommand(Qry, con))
                {
                    cmd.Parameters.Add("@data",SqlDbType.VarBinary).Value = path;
                    con.Open();
                    cmd.ExecuteNonQuery();
                }
            con.Close();
            con.Dispose();
        }

    }

You really shouldn't be exposing your sa password. Nor should your application be logging in as the sa user. — Colin Mackay
– Colin Mackay, Commented May 7, 2013 at 10:59
Execute the command and you'll be set. What is your question? — CodeCaster
– CodeCaster, Commented May 7, 2013 at 11:07
@CodeCaster the problem is, that only handles a single file at the moment — LukeHennerley
– LukeHennerley, Commented May 7, 2013 at 11:10
@LukeHennerley that's nice of you, but OP should mention that, especially since all information after that is missing: in what part he's having trouble. Creating FileUpload's on the fly? Getting input from multiple FileUpload's? Reading all uploaded files from a single FileUpload? Executing multiple queries at once, or running a single insert query for multiple data? — CodeCaster
– CodeCaster, Commented May 7, 2013 at 11:12

Damith · Accepted Answer · 2013-05-08 10:03:50Z

2

try with

foreach (HttpPostedFile uploadedFile in FileUpload1.PostedFiles)
{
    SaveImage(uploadedFile);
}

private void SaveImage(HttpPostedFile file)
{
   using(SqlConnection con = new SqlConnection(ConnectionString))// set ConnectionString
   {
       using(SqlCommand cmd = new SqlCommand(Qry,con)) // set Qry
       {
          cmd.Parameters.AddWithValue("@data", ReadFile(file));
          con.Open();
          cmd.ExecuteNonQuery();
       }
   }
}

private byte[] ReadFile(HttpPostedFile file)
{
    byte[] data = new Byte[file.ContentLength];
    file.InputStream.Read(data, 0, file.ContentLength);
    return data;
}

If you need to insert images from server folder and assume you have array of image paths as imageArray then

foreach (var path in imageArray)
{
    SaveImage(path);
}

private void SaveImage(string path)
{
   using(SqlConnection con = new SqlConnection(ConnectionString))// set ConnectionString
   {
       using(SqlCommand cmd = new SqlCommand(Qry,con)) // set Qry
       {
          cmd.Parameters.AddWithValue("@data", System.IO.File.ReadAllBytes(path));
          con.Open();
          cmd.ExecuteNonQuery();
       }
   }
}

edited May 8, 2013 at 10:03

answered May 7, 2013 at 11:10

Damith

63.2k13 gold badges106 silver badges154 bronze badges

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

5 Comments

Rajesh Over a year ago

@ Damith The File Upload1 has only Posted File not Posted Files do I need to add some References ???

Damith Over a year ago

.NET Framework 4.5 need for this. msdn.microsoft.com/en-us/library/…

Rajesh Over a year ago

@ Damith I have only .Net Framework 4.0 and My OS is Windows XP So it don't support .NET Framework 4.5 Is there any other way I can Access "FileUpload1.PostedFiles" like some references

Damith Over a year ago

then read from saved folder and insert to database one by one.

Rajesh Over a year ago

@ Damith I have tried the way You said and Mentioned the Code in the Answer Part below but that didn't worked

LukeHennerley · Accepted Answer · 2013-05-07 11:10:04Z

1

foreach(HttpPostedFile file in FileUpload1.PostedFiles)
{
  var memoryStream = new MemoryStream();
  file.InputStream.CopyTo(memoryStream);
  string Qry = "insert into tblFiles values(@data)";
        SqlConnection con = new SqlConnection(@"Data Source=ESLHPC17\SQL2008;Initial Catalog=dbFiles;User ID=user;Password=password");

        SqlCommand cmd = new SqlCommand(Qry,con);
        cmd.Parameters.Add("@data") = memoryStream.ToArray();

}

answered May 7, 2013 at 11:10

LukeHennerley

6,4542 gold badges34 silver badges51 bronze badges

1 Comment

CodeCaster Over a year ago

Query, command and connection can be initialized outside the foreach, command does not get executed.

Collectives™ on Stack Overflow

How to Upload Selected Multiple Images into the Database

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related