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
– deweyredman, Commented Feb 18, 2015 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
– deweyredman, Commented Feb 18, 2015 at 22:11
do you have a function that you've written to update the db yet? — deweyredman
– deweyredman, Commented Feb 18, 2015 at 22:12

Community · Accepted Answer · 2017-05-23 12:00:44Z

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, 2017 at 12:00

CommunityBot

11 silver badge

answered Feb 18, 2015 at 22:19

Willian Andrade

3323 silver badges12 bronze badges

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

Comments

gutsmania · Accepted Answer · 2015-02-18 22:19:00Z

0

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/

answered Feb 18, 2015 at 22:19

gutsmania

3121 gold badge2 silver badges10 bronze badges

Comments

Jeff D · Accepted Answer · 2016-11-04 16:16:34Z

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>

user21117112 · Accepted Answer · 2023-01-31 10:21:54Z

0

fg

iuou

uouienter link description here

uiouidfgsdfgddfgdfgdfgdgdgd##

Heading

##*

uio

uiopomkl

hjlkdsg

dsf

dfgdg

Blockquote

answered Jan 31, 2023 at 10:21

user21117112

1

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

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

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related