Databases
StackOverflow2013
Postsdbo
POcannot retrieve data in Jquery after makin $.ajax call using Jsonp
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcannot retrieve data in Jquery after makin $.ajax call using Jsonp
    primarykey
    data
    text
    <p>I've a function used to retrieve the data from my RESTFUL WCF Service. the returned data has to be JSON. </p> <p>on the Client end I have a javascript function called autosuggest like below:</p> <pre><code>function autosuggest(location){ var uri= 'http://localhost:2043/Suggest.svc/GetAirportsjson?location='+location; $.ajax({ url:uri, dataType: 'jsonp', jsonp: 'callback', jsonpCallback: 'jsonpCallback(e)', success: function(e){ alert("success"); } }); }; </code></pre> <p>the Service interface as:</p> <pre><code>[WebInvoke(Method = "GET", ResponseFormat = WebMessageFormat.Xml, BodyStyle = WebMessageBodyStyle.Bare, UriTemplate = "/GetAirportsXML?location={location}")] [OperationContract] List&lt;Suggestions&gt; GetAirportDataXml(string location); [WebInvoke(Method = "GET", ResponseFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Bare, UriTemplate = "/GetAirportsJSON?location={location}")] [OperationContract] List&lt;Suggestions&gt; GetAirportDataJson(string location); </code></pre> <p>And The response observed in Firebug for location=m is </p> <pre><code>[{"AirportCode":"MMZ","AirportName":"Maimana","AreaCode":"701","CountryCode":"AF","CountryName":"Afghanistan"},{"AirportCode":"MZR","AirportName":"Mazar-i-sharif","AreaCode":"701","CountryCode":"AF","CountryName":"Afghanistan"},{"AirportCode":"IMZ","AirportName":"Nimroz","AreaCode":"701","CountryCode":"AF","CountryName":"Afghanistan"},{"AirportCode":"TMR","AirportName":"Aguemar","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"BMW","AirportName":"Bordj Badji Mokhtar","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"IAM","AirportName":"In Amenas","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"MUW","AirportName":"Mascara-Ghriss","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"MZW","AirportName":"Mechria","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"MQV","AirportName":"Mostaganem","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"HME","AirportName":"Oued Irara Apt","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"TMX","AirportName":"Timimoun","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"},{"AirportCode":"TLM","AirportName":"Zenata","AreaCode":"500","CountryCode":"DZ","CountryName":"Algeria"}] </code></pre> <p>And I'll also Provide my service code which is</p> <pre><code>using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.ServiceModel.Activation; namespace AutosuggestAPI.svc { // NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together. [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] public class Suggest : IService1 { public string GetDateTime() { return DateTime.Now.ToString(); } private static List&lt;Suggestions&gt; GetDistinct(List&lt;Suggestions&gt; suggestions) { var length = suggestions.Count; var Arr = new Suggestions[length]; suggestions.CopyTo(Arr); var dist = new HashSet&lt;string&gt;(); foreach (var suggestion in Arr) { if (!dist.Contains(suggestion.AirportCode.ToString())) dist.Add(suggestion.AirportCode.ToString()); else { suggestions.Remove(suggestion); } } return suggestions; } public List&lt;Suggestions&gt; GetAirportDataXml(string location) { var suggestions = new List&lt;Suggestions&gt;(); var val = string.Empty; for (int i = 0; i &lt; 2; i++) { val = i == 0 ? "AirPortName" : "AirPortCode"; SqlConnection conn = null; try { // create and open a connection object conn = new SqlConnection("Server=(local);DataBase=DBAirPortCodes;Integrated Security=SSPI"); conn.Open(); // 1. create a command object identifying // the stored procedure var cmd = new SqlCommand("sp_CheckCondition", conn) { CommandType = CommandType.StoredProcedure }; // 2. set the command object so it knows // to execute a stored procedure // 3. add parameter to command, which // will be passed to the stored procedure cmd.Parameters.Add(new SqlParameter("@lookup", val)); cmd.Parameters.Add(new SqlParameter("@searchfor", location)); var reader = cmd.ExecuteReader(); while (reader.Read()) { var suggestion = new Suggestions() { _airportCode = Convert.ToString(reader["AirPortCode"]).Trim(), _airportName = Convert.ToString(reader["AirPortName"]).Trim(), _areaCode = Convert.ToString(reader["AreaCode"]).Trim(), _countryCode = Convert.ToString(reader["CountryCode"]).Trim(), _countryName = Convert.ToString(reader["CountryName"]).Trim() }; suggestions.Add(suggestion); } } finally { if (conn != null) conn.Close(); } } var distinctList = GetDistinct(suggestions); return distinctList; } List&lt;Suggestions&gt; GetAirportDataJson(string location) { List&lt;Suggestions&gt; suggestions = GetAirportDataXml(location); return suggestions; } public List&lt;Suggestions&gt; GetAirportDataJsonp(string location) { return GetAirportDataXml(location); } public List&lt;Suggestions&gt; GetAllSuggestions() { var suggestions = new List&lt;Suggestions&gt;(); var val = string.Empty; for (int i = 0; i &lt; 2; i++) { val = i == 0 ? "AirPortName" : "AirPortCode"; SqlConnection conn = null; try { // create and open a connection object conn = new SqlConnection("Server=(local);DataBase=DBAirPortCodes;Integrated Security=SSPI"); conn.Open(); var cmd = new SqlCommand("sp_GetAllAirports", conn) { CommandType = CommandType.StoredProcedure }; var reader = cmd.ExecuteReader(); while (reader.Read()) { var suggestion = new Suggestions() { _airportCode = Convert.ToString(reader["AirPortCode"]).Trim(), _airportName = Convert.ToString(reader["AirPortName"]).Trim(), _areaCode = Convert.ToString(reader["AreaCode"]).Trim(), _countryCode = Convert.ToString(reader["CountryCode"]).Trim(), _countryName = Convert.ToString(reader["CountryName"]).Trim() }; suggestions.Add(suggestion); } } finally { if (conn != null) conn.Close(); } } var distinctList = GetDistinct(suggestions); return distinctList; } } } </code></pre> <p>The Problem is that the call is successful and I get the Data in Browser but I cannot catch it in Jquery or Javascript. Can someone help?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAkshay Khandelwal
    1. USAkshay Khandelwal
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COTry adding console.log(e) to your success function and see if you actually get anything, or just an error. Me thinks you are returning json when jsonp is expected.
      singulars
      1. POcannot retrieve data in Jquery after makin $.ajax call using Jsonp
      1. USadeneo
    2. COI want it to be json but service is not on the same domain. hence using jsonp.Also success function is not hit at all. nothing logged after addding console.log(e)
      singulars
      1. POcannot retrieve data in Jquery after makin $.ajax call using Jsonp
      1. USAkshay Khandelwal
    3. COThere is a pretty good probablity that the problem is the returned data. And to use cross domain jsonp the REST service you are using must support it, and return valid jsonp, not json as that will not work. You could do this on the serverside, as that would be really simple, or you could use a service like Yahoo's YQL to convert the data to jsonp. The best option however would probably be to make the REST service support jsonp if you have access to it.
      singulars
      1. POcannot retrieve data in Jquery after makin $.ajax call using Jsonp
      1. USadeneo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload