Jquery DataTable in MVc

Jquery Datatable in MVC

This is my controller Action

Controller Action

public ActionResult Retrieving()

{

var data= db.retrieve();

return Json(new { data = data },JsonRequestBehavior.AllowGet);

}

Iam trying to call this method using jquery datatable

This is my view page and i wrote jquery code and also placed jquery

plugins.

ViewBag.Title = "RetrievingSwAssets";

Layout = "~/Views/Shared/_Admin.cshtml";

}

RetrievingSwAssets

//table

AssetsId

AMSSW_AssetName

AssetType

Vendor

Version

DoP

Location

datatable links

rel="stylesheet" />

jquery datatable links

@section Scripts{

}

But Its Retrieving json format.

Like:{"data":[{"AssetID":"SW-Asset-

1","AMSSW_AssetName":null,"AMSSW_AssetType":"Software Asset","AMSSW_Vendor":null,"AMSSW_Version":null,"Date_of_purchase":null,"CompanyLocation":null},{"AssetID":"SW-Asset-2","AMSSW_AssetName":null,"AMSSW_AssetType":"Software Asset","AMSSW_Vendor":null,"AMSSW_Version":null,"Date_of_purchase":null,"CompanyLocation":null},{"AssetID":"SW-Asset-3","AMSSW_AssetName":"VisualStudio 2017","AMSSW_AssetType":"Software Asset","AMSSW_Vendor":"Micrsoft","AMSSW_Version":"15.2","Date_of_purchase":"2018-06-13","CompanyLocation":"hyd"}]}

I want to display this data in Table format

I don't no where the mistake. Plz solve it...

2 Replies

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

Sankeerth Maraganti8y ago
Instead of action result replace to JSON result
Dharmraj Thakur8y ago
Hello

Please try by changing this line...
public ActionResult Retrieving()

{

  var data= db.retrieve();

  return Json(new { data },JsonRequestBehavior.AllowGet);

}