MVC and Ajax datatable with JSON

Saminda Kotinkaduwa

8y12.4k.NET

Hi Sir,

I have a controller which sends json data to a view and the view supposed to grab that json data and display in the datatable Ajax. but instead view is displaying just RAW json data.

my Controller code is -

public ActionResult Index2()
{
using (Model_Test dbObj = new Model_Test())
{
List testList = dbObj.Test_Table.ToList();
var obj = new { data = testList };
return Json(obj, JsonRequestBehavior.AllowGet);
}
}

my View code is -

@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout.cshtml";
}
"abc" class="display">
Id
Name
Address
"~/Content/jquery.dataTables.min.css" rel="stylesheet" />
@section Scripts{
"~/Scripts/jquery.dataTables.min.js">
}

I tested the datatable with static data and it works fine. so it should be something to do with controller json output. Please help me I am so stuck.

Thanks

3 Replies

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

Katrell Graham7y ago
Hello I am experiencing the same issue were you able to figure this out?
Saminda Kotinkaduwa8y ago
Hi Sanwar,

Thank you very much for your help. I tried using this code and changing mine as relevant but stil im getting just raw json loaded to the page.. I have been strugilling to find this for 4 days now, yet no luck... any chance that u can send a working sample plssss
Sanwar Ranwa8y ago
Hello Saminda

Please check following code and make correction in your code

How to retrive data using ajax in asp.net

ID Name Position Office Age Salary

MVC and Ajax datatable with JSON

How to retrive data using ajax in asp.net