How to fetch data in ASP.Net MVC using AngularJS?

Question

Hi Developers and Engineers, I am trying to fetch data from Database in a table format using AngularJS and Datatables, but when I run the application I can not see any data I don't know what is wrong?

This my App Module:

var app = angular.module('MyApp', ['datatables']); app.controller('homeCtrl', ['$scope', '$http', 'DTOptionsBuilder', 'DTColumnBuilder',
function ($scope, $http, DTOptionsBuilder, DTColumnBuilder) {
    $scope.dtColumns = [
        DTColumnBuilder.newColumn("CustomerID", "Customer ID"),
        DTColumnBuilder.newColumn("CompanyName", "Company Name"),
        DTColumnBuilder.newColumn("ContactName", "Contact Name"),
        DTColumnBuilder.newColumn("ContactTitle", "Contact Title"),
        DTColumnBuilder.newColumn("Address", "Address"),
        DTColumnBuilder.newColumn("City", "City")
    ]

    $scope.dtOptions = DTOptionsBuilder.newOptions().withOption('ajax', {
        url: "/home/getdata",
        type: "POST"
    })
    .withPaginationType('full_numbers')
    .withDisplayLength(10);
}]);

The MVC Controller:

 public class HomeController : Controller
{

    public ActionResult Index()
    {
        return View();
    }
    // Fetching Data from Customer Table
    public ActionResult getData()
    {
        using (MyDatabaseEntities dc = new MyDatabaseEntities())
        {
            return Json(dc.Customers.ToList());
        }
    }


}

the View of the controller and JS Order:

Alexz S. · Accepted Answer · 2016-06-04 12:40:18Z

1

However I'd do it in a different way also redesign your solution, you're missing JsonRequestBehavior.AllowGet as a second parameter in your return Json.

return Json(dc.Customers.ToList(), JsonRequestBehavior.AllowGet);

It is needed as the method signature you're calling deny Json requests in HttpGet method, if you decompile System.Web.Mvc.Controller you will find it.

The get is initially denied to avoid a specific attack with Json, it's called JSON Hijacking, Pill's describe more in his blog Json Hijacking.

edited Jun 4, 2016 at 12:40

answered Jun 4, 2016 at 12:29

Alexz S.

2,5975 gold badges23 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fetch data in ASP.Net MVC using AngularJS?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related