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
