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
Company Name
Branch Name
User Name
User Type
Actions
@Model.MyData.CompanyName
@Model.MyData.BranchName
@Model.MyData.UserName
@Model.MyData.UserType
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("" + item.CompanyName + " " + item.BranchName + " " + item.UserName + " ");
});
},
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

ahmed salahPosted Jun 14, 2023, 11:04 AM
thank you for reply
but issue still exist and both solution posted not solve my issue and not working
Amit MohantyPosted Jun 14, 2023, 9:18 AM
try this
Rajkiran SwainPosted Jun 14, 2023, 9:14 AM
ahmed salahPosted Jun 14, 2023, 8:35 AM
From console debug i get this result
but still can't solve issue
$.each(response, function (index, item) {
console.log("item is " + item)
console.log("index is " + index)
});
EditUser:85 item is 9595
EditUser:86 index is vLoginName
EditUser:85 item is qvUBTS3WkZ/mFbpDQjQsFjsyLR9ehAEWqLedckm3pKZgUlZ/IsH9PFuDXsOto3dXgByvSXRS9ynsBahj38SSkw==
EditUser:86 index is vPassword
EditUser:85 item is A
EditUser:86 index is userMode
EditUser:85 item is 230
EditUser:86 index is id
EditUser:85 item is 0
EditUser:86 index is failedAttempts
EditUser:85 item is ADC Test User
EditUser:86 index is userName
EditUser:85 item is KFoundation-Tawar
EditUser:86 index is branchName
EditUser:85 item is 101KF05
EditUser:86 index is branchCode
EditUser:85 item is Union Co-Operative Society
EditUser:86 index is companyName
EditUser:85 item is S
EditUser:86 index is userType
EditUser:85 item is null
EditUser:86 index is accountStatus
ahmed salahPosted Jun 14, 2023, 7:15 AM
so please what i do to solve issue