asp.net MVC return json

Question

I use $http request to call MVC controller and return data in JSON format. But i not able to get the result in javascript/angualr js. It return entire HTML page. Where i made the mistake?

myapp.controller('MyCtrl', ['$scope', '$http', function ($scope, $http) {
$scope.toggle = function () {
    $http({
        url: "/Admin/FilterMember",
        method: "GET",
        params: { id: $('#txtsearch').val() }
    }).then(function (result) {
        alert(result);
    });
};
}]);

Above is angular script in JS file.

public ActionResult FilterMember(string id)
{
    SqlParameter[] SqlParam = { new SqlParameter("@Filter", id) };
    DataTable dTable = MasterMindDB.dTableSP(DbConn, "SP_Get_MemberList", SqlParam);
    List<Member> member = new List<Member>();

    foreach (DataRow row in dTable.Rows)
    {
        member.Add(new Member
        {
            MemberName = row["Member ID"].ToString(),
            Email = row["Email"].ToString(),
            JoinDate = row["Join Date"].ToString(),
            Status = row["Status"].ToString()
        });
    }
    return View("Member", Json(member, JsonRequestBehavior.AllowGet));
}

Above is MVC controller

Just return Json(member, JsonRequestBehavior.AllowGet)

Nkosi
– Nkosi

2016-09-02 02:47:34 +00:00
Commented Sep 2, 2016 at 2:47 — Nkosi
– Nkosi, Commented Sep 2, 2016 at 2:47

Nkosi · Accepted Answer · 2016-09-02 04:05:23Z

1

This action is for the FilerMember view

[HttpGet]
public ActionResult FilterMember () {
    return View();
}

This action will be called from the client side view. No need to return a ViewResult, just the data

[HttpGet]
public ActionResult GetMemberById(string id) {
    SqlParameter[] SqlParam = { new SqlParameter("@Filter", id) };
    DataTable dTable = MasterMindDB.dTableSP(DbConn, "SP_Get_MemberList", SqlParam);
    List<Member> member = new List<Member>();

    foreach (DataRow row in dTable.Rows) {
        member.Add(new Member {
            MemberName = row["Member ID"].ToString(),
            Email = row["Email"].ToString(),
            JoinDate = row["Join Date"].ToString(),
            Status = row["Status"].ToString()
        });
    }
    //Just return JsonResult.
    return Json(member, JsonRequestBehavior.AllowGet);
}

Updated client

myapp.controller('MyCtrl', ['$scope', '$http', function ($scope, $http) {
$scope.toggle = function () {
    $http({
        url: "/Admin/GetMemberById",
        method: "GET",
        params: { id: $('#txtsearch').val() }
    }).then(function (result) {
        alert(result);
    });
};
}]);

edited Sep 2, 2016 at 4:05

answered Sep 2, 2016 at 2:48

Nkosi

249k38 gold badges472 silver badges506 bronze badges

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

2 Comments

inc Over a year ago

I want return the View because i using Single page application concept. If remove the View, then my view wont render. Do you have any solution. Thx

Nkosi Over a year ago

ok then move the filter call to another action that is responsible for only returning the data.

Collectives™ on Stack Overflow

asp.net MVC return json

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related