parse JSON in jquery Autocomplete

Question

On key entry in autocomplete box, I am returning Key,Value pair from MVC controller in JSON format.

public ActionResult UserNameAutoComplete(string term)
{
    DBEntities db = new DBEntities();

    ...codes to get data from database 

    jsonString += jSearializer.Serialize(userList);
    return Json(jsonString, JsonRequestBehavior.AllowGet);
}

the retruned Json String is [{"UserId":"1","UserName":"admin"},{"UserId":"3","UserName":"newtonsheikh"}]

In the View i am getting this

enter image description here

The jquery is

$("#Username").autocomplete({
    source: '@Url.Action("UserNameAutoComplete")'
});

My question is how do i parse this returned json? The expected output is enter image description here

System.Web.Script.Serialization.JavaScriptSerializer jSearializer = new System.Web.Script.Serialization.JavaScriptSerializer(); object of this class — Newton Sheikh
– Newton Sheikh, Commented Jun 27, 2013 at 11:52

Newton Sheikh · Accepted Answer · 2013-06-28 13:34:39Z

6

solved the issue. i had to change my jquery code. There is no need to change the code for returning the json string.

$("#Username").autocomplete({
        select: function (e, ui) {
            $("#Username").val(ui.item.label);
            return false;
        },

        source: function (request, response) {
            $.ajax({
                url: '@Url.Action("UserNameAutoComplete")',
                data: request,
                success: function (data) {
                    var ParsedObject = $.parseJSON(data);
                    response($.map(ParsedObject, function (item) {
                        return {
                            label: item.UserName,
                            value: item.UserId
                        };

                    }))
                }
            });
        }
    });

answered Jun 28, 2013 at 13:34

Newton Sheikh

1,4062 gold badges21 silver badges43 bronze badges

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

Comments

maxs87 · Accepted Answer · 2013-06-27 14:47:19Z

0

You trying to serialize your dataSet twice. You need use

return Json(jsonString, JsonRequestBehavior.AllowGet);

without(!) jSerializer.

or if you want do this with serializer try return just content of your serialized dataset

jsonString += jSearializer.Serialize(userList);
return Content(jsonString);

answered Jun 27, 2013 at 14:47

maxs87

2,2242 gold badges19 silver badges25 bronze badges

Collectives™ on Stack Overflow

parse JSON in jquery Autocomplete

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related