Data-Table not showing on the record than json format

Question

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

Sachin Singh · Answer

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" } ] }); });

Amit Mohanty · Answer

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.

Sachin Singh · Answer

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

Mageshwaran R · Answer

Hi , please refer this link: https://www.c-sharpcorner.com/blogs/returning-data-in-json-format-in-mvc1

Guest User · Answer

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

Sachin Singh · Answer

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

Guest User · Answer

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

Aarti Gupta · Answer

@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.

Guest User · Answer

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); } }

Amit Mohanty · Answer

Hey try this "~/Scripts/jquery-1.10.2.min.js" > $(document).ready( function () { $.getJSON( "Home/GeteNtsaDataResults" , function (json) { var tr; //Append each row to html table for ( var i = 0; i tr = $( ' ' ); tr.append( " " + json[i].LoginID + " " ); tr.append( " " + json[i].Name + " " ); tr.append( " " + json[i].SSID + " " ); tr.append( " " + json[i].Section + " " ); tr.append( " " + json[i].Role + " " ); tr.append( " " + json[i].LastActivity + " " ); tr.append( " " + json[i].TotalActivity + " " ); $( 'table' ).append(tr); } }); }); 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