Save Images into Sql Server Database Table using asp.net 4.0 ajax

Question

I have a form where users are able to upload images to the website. The images are stored in binary, in the table.

I use ajax and JQuery on the site and it is never reloaded so when a users enter the data and push submit, the page is not reloaded. Instead I use ajax to upload the the data to the server.

When I just passthrough text it looks like this:

$("#storeDataAndImgBtn").bind("click", function () {
    var msg = $("#emailMsg").val();
    var from = $("#fromEmail").val();
    $.ajax({
        type: "POST",
        url: "Default.aspx/storeDataAndImg",
        data: "{\"from\":\"" + from + "\" ,\"msg\":\"" + msg + "\" ,\"value\":\" 'image should be here' \" }",
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        success: function (temp) {
            alert(temp.d);
            $("#mailForm").fadeOut(function () {
                $("#overlay").fadeOut();
            });
        }
    });
    return false;
});

My question is how i can passthrough the image so that I can store it in the database?

Community · Accepted Answer · 2017-05-23 10:30:25Z

1

I am assuming that the image is just a Input Type="File". If this is the case, you cannot access the Input field using Ajax due to security reasons. I believe the best solution is using an IFrame for the submit target. It's not pretty but it works.

SOF - How to make Asynchronous(AJAX) File Upload using iframe

Your other option is to use a Flash/Silverlight/etc plugin to. I am currently using SWFUpload.

SWFUpload

edited May 23, 2017 at 10:30

CommunityBot

11 silver badge

answered Aug 23, 2010 at 19:07

Erik Philips

54.8k11 gold badges133 silver badges158 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:10:50Z

0

If possible, I would suggest not storing the image in the database. Instead, store images on the server's file-system.

Refer here for similar/related questions: store image in database or in a system file?

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Aug 23, 2010 at 15:44

Jeff Dalley

1,3111 gold badge18 silver badges31 bronze badges

2 Comments

Mikael Over a year ago

Okay, so say that I actually change so that I store the images onto the server's file-system instead. How do I (without reloading the page, making a post) store the image onto the file-system?

Jeff Dalley Over a year ago

Hmm, using Ajax this doesn't really happen out of the box; but you may find what you need here: geekswithblogs.net/rashid/archive/2007/08/01/… and also a similar question/answer here: stackoverflow.com/questions/254831/…

Collectives™ on Stack Overflow

Save Images into Sql Server Database Table using asp.net 4.0 ajax

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related