Return List<T> from controller to ajax in asp.net mvc4

Question

I am trying to get a list from controller upon a jquery ajax call.

But it returns an error 'Unexpected token S'.

UPDATE- Controller code is Ok. It successfully preparing the list. But ajax shows this error.

jquery ajax code-

var urlData = '@Url.Action("GetThanas", "AgentKycEntry")';
$.ajax({
type: "POST",
url: urlData,
contentType: "application/json; charset=utf-8",
data: "{'id':'" + selectedVal + "'}",
dataType: "json",
success: function (result) {
//tasks with restul
},
error: function (request, status, error) {
alert("Request: " + request + " Status: " + status + " Error: " + error);
}
});

Code in controller

    [HttpPost]
    public List<Thana> GetThanas(int id)
    {
        return Thana.GetThanaList(id);
    }

UPDATE- Model code

   public class Thana
{

    public String ThanaId { get; set; }
    public String ThanaName { get; set; }

    public Thana() { }


    public static List<Thana> GetThanaList(Int32 districtId)
    {
        List<Thana> thanaList = new List<Thana>();


        String ConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
        using (SqlConnection Connection = new SqlConnection(ConnectionString))
        {
            using (SqlCommand cmd = new SqlCommand("Select ThanaId,ThanaName From tblThanas where ThanaId<>0 And DistrictId=" + districtId + " or DistrictId=0 order By DisplayOrder ASC, ThanaName ASC ", Connection))
            {
                Connection.Open();
                SqlDataReader Reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (Reader.Read())
                {
                    Thana thana = new Thana();
                    thana.ThanaId = Reader["ThanaId"].ToString();
                    thana.ThanaName = Reader["ThanaName"].ToString();
                    thanaList.Add(thana);
                }
                if (!Reader.IsClosed)
                {
                    Reader.Close();
                }
            }
        }



        return thanaList;
    }

}

Any suggestion ?

Where do you get this error? in controller?

MRB
– MRB

2013-11-03 07:20:57 +00:00
Commented Nov 3, 2013 at 7:20 — MRB
– MRB, Commented Nov 3, 2013 at 7:20
in ajax when getting the list. controller is ok.

s.k.paul
– s.k.paul

2013-11-03 07:24:03 +00:00
Commented Nov 3, 2013 at 7:24 — s.k.paul
– s.k.paul, Commented Nov 3, 2013 at 7:24

WannaCSharp · Accepted Answer · 2013-11-03 08:27:36Z

3

Return it as Json, try this.

public JsonResult GetThanas(int id)
    {
        var list =  Thana.GetThanaList(id);
        return Json(list, JsonRequestBehavior.AllowGet);
    }

EDIT:

success: function (result) {
//tasks with restul
    alert(result[0].ThanaName);
},

edited Nov 3, 2013 at 8:27

answered Nov 3, 2013 at 7:35

WannaCSharp

1,8982 gold badges13 silver badges19 bronze badges

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

6 Comments

s.k.paul Over a year ago

I tried this. 'Unexpected token S' error has gone. But I am not getting the List of data. result= [object Object],[object Object],.....

WannaCSharp Over a year ago

Can I see GetThanaList ?

s.k.paul Over a year ago

Json.parse(result) returns nothing.

WannaCSharp Over a year ago

You need to store it in a variable, like var data = Json.parse(result)

s.k.paul Over a year ago

let us continue this discussion in chat

|

Collectives™ on Stack Overflow

Return List<T> from controller to ajax in asp.net mvc4

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related