javascript or ajax to update database with asp.net mvc?

Question

I have a function here from a change event on a dropdownlist. When the selection gets changed I want to update a row in my database. Should I use javascript or ajax. I don't want the page to be refreshed. I think it should be ajax, but not sure? If ajax, can anyone point me to a tutorial/video/etc?

Here is where I want to update my db row.

var statusdropdown = document.getElementById("enumstatus");
statusdropdown.addEventListener("change", function(event) {
    // call db and update row
}, false);

javascript or ajax? ...you realize ajax means asynchronous javascript(and xml)...right? You definitely want ajax. — deweyredman, Feb 18 '15 at 22:09
not too familiar with asp.net...you basically want to pass the current value of #enumstatus to the function that updates the db. — deweyredman, Feb 18 '15 at 22:11
do you have a function that you've written to update the db yet? — deweyredman, Feb 18 '15 at 22:12

score 2 · Accepted Answer · edited May 23 '17 at 12:00

2

Looks like you using asp.net mvc.

You can write your ajax calls with pure javascript Ajax docs or the easiest way, using JQuery.

You need to add one action on your controller to receive the ajax data, and then insert/update your db.

See this, this and this.

edited May 23 '17 at 12:00

Community

1
1

answered Feb 18 '15 at 22:19

Willian Andrade

332
3
11

score 0 · Answer 2 · answered Feb 18 '15 at 22:19

Most common scenario would be making an ajax call using HTTP POST/PUT to a controller method, which would then handle the data and update the database directly or pass through to your service/data layer code.

Probably the easiest way to make the call would be using the jQuery.ajax method. Documentation can be found here: http://api.jquery.com/jquery.ajax/

score 0 · Answer 3 · answered Nov 04 '16 at 16:16

You can try something like this

<script type="text/javascript">
    $(function () {
        $('#btnSubmit').click(function () {
            var name = $('#TextBox1').val();
            var email = $('#TextBox2').val();
            if (name != '' && email != '') {
                $.ajax
                    ({
                        type: 'POST',
                        url: 'Home/UpdateDB',     //if it is plain asp.net then UpdateDB is declared as WebMethod 
                        async: false,
                        data: "{'name':'" + name + "','email':'" + email + "'}",
                        contentType: 'application/json; charset =utf-8',
                        success: function (data) {
                            var obj = data.d;
                            if (obj == 'true') {
                                $('#TextBox1').val('');
                                $('#TextBox2').val('');
                                alert("Data Saved Successfully");
                            }
                        },
                        error: function (result) {
                            alert("Error Occured, Try Again");
                        }
                    });
            }
        })
    });
</script>

javascript or ajax to update database with asp.net mvc?

3 Answers3