Data-Table not showing on the record than json format

Hi Team

I want my View be on the dataTable and using it, but the record is return as json format. How do i fix this issue?

@{
ViewBag.Title = "People_Lists";
}
"~/Content/bootstrap.min.css" rel="stylesheet" />
"~/Scripts/jquery-3.5.1.min.js">
"~/Scripts/bootstrap.min.js">
"~/Content/bootstrap.min.css" rel="stylesheet" />
"~/Scripts/jquery.dataTables.min.js">
"~/Scripts/dataTables.bootstrap4.min.js">
"text/javascript">
$(document).ready(function () {
$('#dataTable').DataTable({
"ajax": {
"url": "/Home/GeteNtsaDataResults",
"type": "GET",
"datatype": "json"
},
"columns": [
{ "data": "LoginID" },
{ "data": "Name" },
{ "data": "SSID" },
{ "data": "Section" },
{ "data": "Role" },
{ "data": "LastActivity" },
{ "data": "TotalActivity" }
]
});
});
class="container py-4">
class="text-center text-uppercase">
"dataTable_wrapper">

"dataTable" class="table table-bordered table-striped">

LoginID

Name

SSID

Section

Role

LastActivity

TotalActivity

Dear @Aarti Gupta Ji, thank you for teaching me what to do or not. For your kind information, my answer was a suggestion to him. I am not telling this is the right answer. Let him decide the answer was related to his question or not.

remove jquery and just use below files

"~/Content/bootstrap.min.css" rel="stylesheet" />
"~/Scripts/bootstrap.min.js">
"~/Content/bootstrap.min.css" rel="stylesheet" />
"~/Scripts/jquery.dataTables.min.js">
"~/Scripts/dataTables.bootstrap4.min.js">

if this doesn't work then check your list in controller and let me know what's the result

Hi ,

please refer this link:

https://www.c-sharpcorner.com/blogs/returning-data-in-json-format-in-mvc1

Hi Singh

Still same response as json format, no error at all when debug it.

@Gco just copy paste and test whether is it working or not?

Hi Sigh

Please specific for me the need to have dataSrc "" there is no definition there its empty dont understand

@Amit mohanty please don't do that , first read the question and then answer , here the question belongs to datatable and your answer is for html table, these are completely unrelatable.

you are doing a small mistake please update like below

$(document).ready(function () {
$('#dataTable').DataTable({
"ajax": {
"url": "/Home/GeteNtsaDataResults",
"type": "GET",
"datatype": "json" ,
"dataSrc": ""
},
"columns": [
{ "data": "LoginID" },
{ "data": "Name" },
{ "data": "SSID" },
{ "data": "Section" },
{ "data": "Role" },
{ "data": "LastActivity" },
{ "data": "TotalActivity" }
]
});
});

Hi Amit

I am still getting the same responce, ok let me share my controller logic for clarity.

//GET:Data-Using-DataTable.
public ActionResult GeteNtsaDataResults()
{
using (eNtsaRegistration_2 model = new eNtsaRegistration_2())
{
List eNtsaRegs = cb.RegPeopleLists.ToList();
return Json(new { data = eNtsaRegs }, JsonRequestBehavior.AllowGet);
}
}

Hey try this

"~/Scripts/jquery-1.10.2.min.js">
class="container py-4">
class="text-center text-uppercase">
"dataTable_wrapper">

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
Dear @Aarti Gupta Ji, thank you for teaching me what to do or not. For your kind information, my answer was a suggestion to him. I am not telling this is the right answer. Let him decide the answer was related to his question or not.
+4
Sachin Singh6y ago
remove jquery and just use below files
"~/Content/bootstrap.min.css" rel="stylesheet" />

"~/Scripts/bootstrap.min.js">
"~/Content/bootstrap.min.css" rel="stylesheet" />
"~/Scripts/jquery.dataTables.min.js">
"~/Scripts/dataTables.bootstrap4.min.js">
if this doesn't work then check your list in controller and let me know what's the result
+4
Mageshwaran R6y ago
Hi ,
please refer this link:
https://www.c-sharpcorner.com/blogs/returning-data-in-json-format-in-mvc1
+3
Guest User6y ago
Hi Singh

Still same response as json format, no error at all when debug it.
+3
Sachin Singh6y ago
@Gco just copy paste and test whether is it working or not?
+3
Guest User6y ago
Hi Sigh

Please specific for me the need to have dataSrc "" there is no definition there its empty dont understand
+3
Aarti Gupta6y ago
@Amit mohanty please don't do that , first read the question and then answer , here the question belongs to datatable and your answer is for html table, these are completely unrelatable.
+3
Sachin Singh6y ago
you are doing a small mistake please update like below
$(document).ready(function () {
        $('#dataTable').DataTable({
            "ajax": {
                "url": "/Home/GeteNtsaDataResults",
                "type": "GET",
                "datatype": "json"  ,
                 "dataSrc": ""

            },
            "columns": [
                { "data": "LoginID" },
                { "data": "Name" },
                { "data": "SSID" },
                { "data": "Section" },
                { "data": "Role" },
                { "data": "LastActivity" },
                { "data": "TotalActivity" }
            ]
        });
    });
+5
Guest User6y ago
Hi Amit
I am still getting the same responce, ok let me share my controller logic for clarity.
//GET:Data-Using-DataTable.
     public ActionResult GeteNtsaDataResults()
     {
         using (eNtsaRegistration_2 model = new eNtsaRegistration_2())
         {
             List eNtsaRegs = cb.RegPeopleLists.ToList();
             return Json(new { data = eNtsaRegs }, JsonRequestBehavior.AllowGet);
         }
     }
+3
Amit Mohanty6y ago
Hey try this
"~/Scripts/jquery-1.10.2.min.js">



class="container py-4">
    class="text-center text-uppercase">
    "dataTable_wrapper">
"dataTable" class="table table-bordered table-striped">
LoginID
Name
SSID
Section
Role
LastActivity
TotalActivity