.NET WebService returns XML instead of JSON

Question

I have .NET web service which supposed to return the result as JSON, but it returns it as XML? Here is my code.

[WebService(Namespace = "http://tempuri.org/MyService")]
[ScriptService]
public class MyService : System.Web.Services.WebService
{
    [WebMethod, ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public List<MyData> GetMyData(string dataFilter, string param)
    {
        if (dataFilter.ToLower() == "filterValue")
            return getData(param);
        return null;
    } 
}
public class MyData
{
    public string id { get; set; }
    public string name { get; set; }
    protected internal MyData() { } 
}

And here is the web.config

<system.web>
<compilation debug="true" targetFramework="4.0"/>
<httpRuntime/>
<customErrors mode="Off"/>
<webServices>
  <protocols>
    <add name="HttpGet"/>
    <add name="HttpPost"/>
  </protocols>
</webServices>
<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>

EDIT The web service is working fine only when passing digits in the parameters but it returns internal server error when passing characters inside the parameters. I got confused :O

Bhavanaditya D R · Accepted Answer · 2017-01-03 04:59:13Z

1

Try this code it may help you. Install Newtonsoft.Json package

Code

    public class HelloWorldData
    {
        public String Message;
    }

    [WebMethod]
    public void Select()
    {
        JavaScriptSerializer js = new JavaScriptSerializer();
        Context.Response.Clear();
        Context.Response.ContentType = "application/json";
        HelloWorldData data = new HelloWorldData();
        string sql = "exec YOUR_SP_NAME";
        SqlDataAdapter da = new SqlDataAdapter(sql, System.Configuration.ConfigurationManager.AppSettings["BB_CONSTR"]);
        DataSet ds = new DataSet();
        da.Fill(ds);
        Context.Response.Write(JsonConvert.SerializeObject(ds, Newtonsoft.Json.Formatting.Indented));
    }

edited Jan 3, 2017 at 4:59

answered Jan 3, 2017 at 4:32

Bhavanaditya D R

5583 gold badges8 silver badges24 bronze badges

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

2 Comments

user987654 Over a year ago

Your code returns JSON format but it does not contain an object to parse it. {[{"Test":"200"}]} but i want it to return {"d":[{"Test":"200"}]}

Bhavanaditya D R Over a year ago

can u share the screenshot of results.

Collectives™ on Stack Overflow

.NET WebService returns XML instead of 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