Asp.net web service return json

Gaurav Pal

11y3.6k

I am using below code for my web service. I want return value in json. but this code return value in XML format only.

[WebMethod]

[ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]

public bool login(string uname, string pwd)

{

//SqlConnection con = new SqlConnection();

//SqlCommand cmd = new SqlCommand();

//con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;

//SqlDataAdapter da = new SqlDataAdapter("select * from UserList where UserName ='" + uname + "' and password='" + pwd + "' ", con);

//DataSet ds = new DataSet();

//da.Fill(ds);

//return ds;

SqlConnection con = new SqlConnection();

SqlCommand cmd = new SqlCommand();

con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;

if (con.State == ConnectionState.Closed)

{

con.Open();

}

cmd.CommandText = "select * from UserList where UserName=@username and Password=@pwd";

cmd.Connection = con;

cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = uname;

cmd.Parameters.Add("@pwd", SqlDbType.VarChar, 50).Value = pwd;

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read() == true)

{

return true;

}

else

{

return false;

}

con.Close();

}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Hi Gaurav, you can give link to iphone developer it wil return json response only.

http://localhost:51816/loginwebservice.asmx/login?uname=admin&pwd=test
here you have inform method name and number of parameters like below

WebService1 obj = new WebService1(); //call the webservice class name
string val= obj.CheckFeedSubmission(); // Call the webservice method name
Response.Write(val); //Here return json results
Gaurav Pal11y ago
but i am not using web service like a object i am providing a link to iphone developer like this

http://localhost:51816/loginwebservice.asmx/login?uname=admin&pwd=test
Raja T11y ago
Hi Gaurav,

Yes it is return json results.

Are you runing directily webservice page like below url in
http://localhost:52541/WebService1.asmx

It will returns output like xml only.
xmlns="http://tempuri.org/">{"result":"success","message":"null"}:

But you can use call the webservice methode in new file like webservices_consumping.aspx
here you can inlcude the webservies and call the method like below
using TestDemo.ServiceReference1; //webserive name
namespace TestDemo
{
public partial class webservices_consumping : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
WebService1 obj = new WebService1(); //call the webservice class name
string val= obj.CheckFeedSubmission(); // Call the webservice method name
Response.Write(val); //Here return json results

}
}
}

Output like

{"result":"success","message":"null"}
Gaurav Pal11y ago
This XML file does not appear to have any style information associated with it. The document tree is shown below.
xmlns="http://tempuri.org/">
[{"EmployeeId":1,"EmployeeName":"Sachin","EmployeeSalary":100},{"EmployeeId":102,"EmployeeName":"Koli","EmployeeSalary":101}]

i am getting above result .
Manas Mohapatra11y ago
Which code you tried?(Raja and me provided two solutions).
Gaurav Pal11y ago
Are u sure above result is in json format?
i think this code is in xml format.
Raja T11y ago
for your reference checkout below url

http://forums.asp.net/t/1924293.aspx?how+to+create+JSON+webservice+in+asp+net+
Raja T11y ago
Hi Gaurav, try like this,

You can manual formed JSON in your code like below sample

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]//Specify return format.
public string CheckFeedSubmission()
{
string msg="";

try
{
msg ="{\"result\":\"success\",\"message\":\"null\"}:";
return msg;
}
catch (Exception ex)
{

msg = "{\"result\":\"fail\",\"message\":\"Opps wehave an error! Exception message:" + ex.Message+"}:";
}
return msg;
}

output like below:

xmlns="http://tempuri.org/">{"result":"success","message":"null"}:
Manas Mohapatra11y ago
Hi,

As per your code you should get json format only. Please try to use:

return new JavaScriptSerializer().Serialize(true); // Instead of return true