ahmed salah

ahmed salah

  • 1.2k
  • 547
  • 66.7k

How to load data on datatable after update data to see last updated da

Jun 14 2023 6:41 AM

How to load data on datatable after update data to see last updated data using jquery ajax ?

I work on asp.net razor page .i i face issue i can't load data on

datatable using jquery ajax 

when load data for first time data table load data correctly

<table id="myDataTable" class="table" style="margin-top:20px;">
    <thead>
        <tr>
            <th>Company Name</th>
            <th>Branch Name</th>
            <th>User Name</th>
            <th>User Type</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>

        <tr>
            <td>@Model.MyData.CompanyName</td>
            <td>@Model.MyData.BranchName</td>
            <td>@Model.MyData.UserName</td>
            <td>@Model.MyData.UserType</td>
            <td>
                <button id="editDataBtn" style="width:100px;" class="btn btn-primary edit-btn" data-id="@Model.MyData.ID">Edit</button>
            </td>
        </tr>

    </tbody>
</table>

after update data i need to get updated data so i make as below :

            $("#updatedatabtn").click(function () {
                var userId = $("#userId").val();
                $.ajax({
                    url: '?handler=RefreshDataTable',
 
                    dataType: 'json',
                    data: { UserId: userId },
                    success: function (result) {
                        console.log(result);
                        $("#myDataTable tbody").empty();
                        $.each(result, function (index, item) {
                            $("#myDataTable tbody").append("<tr><td>" + item.CompanyName + "</td><td>" + item.BranchName + "</td><td>" + item.UserName + "</td> </tr>");
                        });
                    },
                    error: function (xhr, status, error) {
                        console.error("AJAX request failed: " + error);
                    }
                });
            });

public JsonResult OnGetRefreshDataTable(string UserId)
        {
            var result = userService.GetUserDetails(UserId.ToString());
            MyData = result.Result;
            return new JsonResult(MyData);

        }

but i get error 

expected result on datatable must be only one row because it display user details for only one user

error details


Answers (5)