Add update and delete to SQL database in a single view .NET MVC

Hello,

You can use Partial view concept for submit your form data and reload the same partial view on success. Refer below code:

Main Form:
$(document).ready(function () {
fneRegConfiguration();
});

//loading eReg configuration partial view
    function fneRegConfiguration() {
        $.ajax({
            type: "POST",
            url: "../Home/_eRegConfiguration",
            success: function (response) {
                // assign partail view table to div
                $("#dv_eRegConfiguration").html(response);
                
            }
        });
    }

on Partial View:

 function PostGlobalConfiguration() {

        var globalData = new FormData($('#frmGlobalConfiguration')[0]);
        $.ajax({
            type: "POST",
            url: "../Home/SaveGlobalConfiguration",
            processData: false,
            contentType: false,
            data: globalData,
            success: function (response) {
                 fneRegConfiguration();
           }
}

Using this concept you can Add, Update and Delete in a single view or without redirecting to another page and without refresh the main page in .net mvc

If you have any more query, ask me freely.