How to upload multiple files using ajaxfileupload in ASP.NET to database?

Question

0.00/5 (No votes)

See more:

Hi guys! I'v been trying to upload six images using ajaxfileupload in asp.net to MSSQL server but it always save only one image. Kindly help me on solving this one. You can also provide better alternatives on achieving the same goal.

What I have tried:

Here is the aspx code:

C#

<div class="divTableBody">
                  <div class="divTableRow">
                     <div class="divTableCell">Thumbnail Images:
                       </div>
                        <div class="divTableCell"> 
                           <asp:AjaxFileUpload ID="itemFileUpload3" 
                           runat="server" 
                           OnUploadComplete="itemImage3OnUpload" 
                           MaximumNumberOfFiles="10" Width="420px"/>
                           <p  id="itemImage3Validate"></p> 
                       </div>
                  </div>
              </div>

And here is the aspx.cs code:

C#

protected void itemImage3OnUpload(object sender, AjaxFileUploadEventArgs 
      e)
    {

    string filename = e.FileName;
    Session["PicturePath3"] = filename;
    if (itemType1.Checked)
    {
        itemFileUpload3.SaveAs(Server.MapPath("~/Images/Sub Images/") +  
   filename);
    }
    else if (itemType2.Checked)
    {
        itemFileUpload3.SaveAs(Server.MapPath("~/Images/Sub Images/") + 
   filename);
    }

}

   protected void itemSaveButton_Click(object sender, EventArgs e)
   {

    try
    {

        string itemThumbImage = Session["PicturePath3"].ToString();


        int itemInstrumentID = 
       ConnectionClassGuitarItems.GetItemIDByNameAndModel
             (item_brandId,item_model);

        var subImg = new thumbnailImage
        {
            instrumentId = itemInstrumentID,
            subimages = itemThumbImage
        };


        ConnectionClassGuitarItems.AddThumnailImage(subImg);
        ScriptManager.RegisterStartupScript(this.Page,this.GetType()
       , "msgboxScc", "btnClickSuccess();", true);

        ClearTextFields2();

    }
    catch (Exception)
    {
        ScriptManager.RegisterStartupScript(this.Page, this.GetType()
     , "msgboxErr", "btnClickFail();", true);
    }


   }

And then I will add my images using this code:

C#

public static void AddThumnailImage(thumbnailImage subImg)
{
    using (MusicStoreDBEntities obj = new MusicStoreDBEntities())
    {

        obj.thumbnailImages.Add(subImg);
        obj.SaveChanges();
    }
}

Posted 16-Sep-17 5:37am

BebeSaiyan

Updated 29-Apr-18 7:48am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2017-09-16T13:25:00

UploadedComplete is the event on the server that you should be listen to:

Quote:
Raised on the server when a file is uploaded successfully. In this event an instance of AjaxFileUploadEventArgs is passed in the argument that contains file name, size and content type.

More information about the control's events here: AjaxFileUpload example to upload multiple files - CodingFusion[^]

NOTE: Google Search is your friend - lots of information out there... I'm a MVC programmer, so had to look this up. The information above was found using this: asp.net ajaxfileupload example - Google Search[^]

Mahesh_111 · Answer 2 · 2018-04-29T07:49:00

please try below code

protected void ajaxUpload1_UploadComplete(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e)
{
id += 1;
string filename = Path.GetFileName(e.FileName);
string filepath = Server.MapPath("~/Images/Gallery/" + filename);
ajaxUpload1.SaveAs(filepath);

string Insert = "Insert into slider (slid,slurl) values (" + @id + ",'" + @IMAGE_PATH + "')";
SqlCommand cmd = new SqlCommand(Insert, con);
cmd.CommandType = CommandType.Text;
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
con.Close();
cmd.Dispose();
}
}

How to upload multiple files using ajaxfileupload in ASP.NET to database?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0