JQuery getJSON call to MVC Controller/Action but not executing all function after get data

Question

0.00/5 (No votes)

See more:

Hi,
This is probably something simple. The following JQuery call is executing and calling the controller. The controller is executing correctly. I used the sample data that's commented out to verify that the templates were working also.

However, the (var response = data.location;) function is not executing in the browser. Any thoughts or other ways I can debug this?

C#

function getLocations()
{    
    $.getJSON("/MapSearch/SearchLocationJson", function (data)
    {
        alert('show');       
        var response = data.location;       
        for (var i = response.length - 1; i >= 0; i--)
        {
        keywords.push(response[i]["StrLocation"]);
        kLat.push(response[i]["StrLat"]);
        kLng.push(response[i]["StrLng"]);
      }
      $("#suburbField").show();
      $("#loadingLabel").hide();
    });
}

SearchLocationJson Action execute well but alert('show') is not executing. i googled but not find the solution. Please help.
my action code is

C#

public JsonResult SearchLocationJson()
       {
           var Getlocation = from r in odbe.ODB_LLg_Master
                             orderby r.Pcode descending
                            // select r;
                           select new
                           {
                               StrLocation = (r.A + "," + r.B+ "," + "VIC"),
                               StrL = r.L1,
                               StrL1 = r.L2
                           };
           return Json(Getlocation, JsonRequestBehavior.AllowGet);
       }

Thanks!

Posted 1-Nov-15 21:54pm

ErBhati

Updated 2-Nov-15 0:26am

v5

Add a Solution

Comments

Gyaneswar kumar 2-Nov-15 5:10am

Add method attribute into that method to get Json fomrat as return type.

ErBhati 2-Nov-15 5:25am

Sorry,I didn't understand your answer .

2 solutions

Solution 1

C#

public JsonResult SearchLocationJson()
       {
           var location = (from r in odbe.ODB_LLg_Master
                             orderby r.Pcode descending
                            // select r;
                           select new
                           {
                               StrLocation = (r.A + "," + r.B+ "," + "VIC"),
                               StrL = r.L1,
                               StrL1 = r.L2
                           }).ToList();
           return Json(location, JsonRequestBehavior.AllowGet);
       }

JavaScript

function getLocations()
{    
    $.getJSON("/MapSearch/SearchLocationJson", function (data)
    {
        alert('show');             
        for (var i = data.length - 1; i >= 0; i--)
        {
        keywords.push(data[i].StrLocation);
        kLat.push(data[i].StrLat);
        kLng.push(data[i].StrLng);
      }
      $("#suburbField").show();
      $("#loadingLabel").hide();
    });
}

You don't have to return the SelectList, as it used for Dropdown items. Rather simply return the list as json and use it.
Try the above and let me know if it works.

-KR

Posted 1-Nov-15 22:23pm

Krunal Rohit

Updated 1-Nov-15 23:06pm

v3

Comments

ErBhati 2-Nov-15 4:34am

dear Rohit,
Thanks for reply but this code not working also...

Krunal Rohit 2-Nov-15 4:35am

I've updated the code.
What's the error ?

-KR

ErBhati 2-Nov-15 4:41am

yes you posted after updation in my code but alert('show'); still not showing when i execute.
there is no error shows.

Krunal Rohit 2-Nov-15 4:45am

try with @Url.Action("SearchLocationJson", "WorkOrder") in $.getJSON(...)
and are you calling function getLocations() anywhere in your code ?

-KR

ErBhati 2-Nov-15 5:01am

'@Url.Action("SearchLocationJson","MapSearch")' not working in $.getJSON(...)

ErBhati 2-Nov-15 4:48am

I am try this also.
here is code
$.ajax({
url: '@Url.Action("SearchLocationJson","MapSearch")',
contentType: "application/json; charset=utf-8",
async: false,
dataType: 'json',
success: function (data)
//$.getJSON("/MapSearch/SearchLocationJson", {}, function (data)
{
alert('show');

var response = data;
for (var i = response.length - 1; i >= 0; i--) {
keywords.push(response[i]["StrLocation"]);
kLat.push(response[i]["StrLat"]);
kLng.push(response[i]["StrLng"]);
}
$("#suburbField").show();
$("#loadingLabel").hide();
}
});

Krunal Rohit 2-Nov-15 4:51am

set async: true.
And you sure, put a breakpoint to the action method. See if the control reaches there or not.

-KR

ErBhati 2-Nov-15 4:55am

yes i put a breakdown in my action. control reaches there.

Krunal Rohit 2-Nov-15 5:01am

And set the debugger; before your alert and check if data is coming from the server.

-KR

ErBhati 2-Nov-15 5:00am

But '@Url.Action("SearchLocationJson","MapSearch")' not working

Krunal Rohit 2-Nov-15 5:06am

Please debug your code properly, use F11.

-KR

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ErBhati · Accepted Answer · 2015-11-02T00:47:00

Thanks for suggestion and your support. now i found the problem. The problem is MaxJsonLength:(The default value for this is 2097152 characters, that is equal to 4 MB of Unicode string data.). I have billions of record in my table . so there is MaxLength Problem. If i select few thousand records than its work properly.

And i solve this problem by using this code. :-

C#

var jsonResult = Json(Getlocation, JsonRequestBehavior.AllowGet);
jsonResult.maxJsonLength = int.MaxValue;
return jsonResult;