how to return jsondata using webservice?

rahul patil

6y832.NET

I want to return json data when filled the webservice page?

issue is when click on Invoke button Data is not displayed

By default the webmethod is post type

WebService1.asmx.cs

namespace WebServiceDemo
{
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnn"].ConnectionString);
[WebMethod]
[ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
public string InsertData(string fname, string mname, string lname, string emailid, string password, string contactno, string hobby, string address, string countrycodenum)
{
cn.Open();
string data = "";
string insertquery = "insert into tblstudent(fname, mname, lname, emailid, password, contactno,hobby,address,countrycodenum)values(@fname,@mname,@lname,@emailid,@password,@contactno,@hobby,@address,@countrycodenum)";
SqlCommand cmd = new SqlCommand(insertquery, cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@fname", fname);
cmd.Parameters.AddWithValue("@mname", mname);
cmd.Parameters.AddWithValue("@lname", lname);
cmd.Parameters.AddWithValue("@emailid", emailid);
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@contactno", contactno);
cmd.Parameters.AddWithValue("@hobby", hobby);
cmd.Parameters.AddWithValue("@address", address);
cmd.Parameters.AddWithValue("@countrycodenum", countrycodenum);
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Console.WriteLine("Insert Successfully");
}
else
{
Console.WriteLine("Not Insert Successfully");
}
cn.Close();
return data;
}
}
}

Web.config

"HttpGet"/>
"HttpPost"/>

Data is inserted in table But I want to return json data when user click on Invoke button?

8 Replies

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

Jignesh Kumar6y ago
As per your code snippet you are returning empty string as data. You Can create class with all property and convert as json object and return it.
0
rahul patil6y ago
hello Jignesh Kumar
I alredy see this link via google
still I m facing this issue

I add this line but this line also not worked

[ScriptMethod(ResponseFormat = ResponseFormat.Json)]

In my below code data variable is return null because I does not store the anything in the data
public class WebService1 : System.Web.Services.WebService
    {
        SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnn"].ConnectionString);
        [WebMethod]
        [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
        public string InsertData(string fname, string mname, string lname, string emailid, string password, string contactno, string hobby, string address, string countrycodenum)
        {
            cn.Open();
            string data = "";
            string insertquery = "insert into tblstudent(fname, mname, lname, emailid, password, contactno,hobby,address,countrycodenum)values(@fname,@mname,@lname,@emailid,@password,@contactno,@hobby,@address,@countrycodenum)";

            SqlCommand cmd = new SqlCommand(insertquery, cn);
            //cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@fname", fname);
            cmd.Parameters.AddWithValue("@mname", mname);
            cmd.Parameters.AddWithValue("@lname", lname);
            cmd.Parameters.AddWithValue("@emailid", emailid);
            cmd.Parameters.AddWithValue("@password", password);
            cmd.Parameters.AddWithValue("@contactno", contactno);
            cmd.Parameters.AddWithValue("@hobby", hobby);
            cmd.Parameters.AddWithValue("@address", address);
            cmd.Parameters.AddWithValue("@countrycodenum", countrycodenum);

            int i = cmd.ExecuteNonQuery();
            if (i > 0)
            {
                Console.WriteLine("Insert Successfully");
            }
            else
            {
                Console.WriteLine("Not Insert Successfully");
            }
            cn.Close();

            return data;
        }
    }
I want to store the data in json?
please give any suggestion or any link to solve the issue
0
Jignesh Kumar6y ago
Hi,

Please try this link which will help you,
https://www.c-sharpcorner.com/article/return-json-response-from-webservice-in-Asp-Net/
0
Salman Beg6y ago
Please debug the applications and check why it is not inserting. Probably you are getting some error. Thanks.
0
rahul patil6y ago
get the data from the table working fine but when insert data in table then not display the any data?
0
Salman Beg6y ago
First check whether you are getting data or not in ds. Also in that article sample project is exists and you can compare if you have missed anything. Thanks
0
rahul patil6y ago
Hi Salman Beg

not display the json data
displaying the empty curly braces

I update my code:
[WebService(Namespace = "http://tempuri.org/")]
  [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
  [System.ComponentModel.ToolboxItem(false)]
  // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
  //[System.Web.Script.Services.ScriptService]
  public class WebService1 : System.Web.Services.WebService
  {
      SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnn"].ConnectionString);
      [WebMethod]
      public string InsertData(string fname, string mname, string lname, string emailid, string password, string contactno, string hobby, string address, string countrycodenum)
      {
          cn.Open();
          SqlDataAdapter da = new SqlDataAdapter();
          DataSet ds = new DataSet();

          string insertquery = "insert into tblstudent(fname, mname, lname, emailid, password, contactno,hobby,address,countrycodenum)values(@fname,@mname,@lname,@emailid,@password,@contactno,@hobby,@address,@countrycodenum)";

          SqlCommand cmd = new SqlCommand(insertquery, cn);
          cmd.CommandType = CommandType.Text;
          cmd.Parameters.AddWithValue("@fname", fname);
          cmd.Parameters.AddWithValue("@mname", mname);
          cmd.Parameters.AddWithValue("@lname", lname);
          cmd.Parameters.AddWithValue("@emailid", emailid);
          cmd.Parameters.AddWithValue("@password", password);
          cmd.Parameters.AddWithValue("@contactno", contactno);
          cmd.Parameters.AddWithValue("@hobby", hobby);
          cmd.Parameters.AddWithValue("@address", address);
          cmd.Parameters.AddWithValue("@countrycodenum", countrycodenum);

          int i = cmd.ExecuteNonQuery();
          da.SelectCommand = cmd;
          da.Fill(ds);

          return JsonConvert.SerializeObject(ds, Newtonsoft.Json.Formatting.Indented);

      }
which place I m doing wrong?help
0
Salman Beg6y ago
Hey it is not returning any value because data variable contains null. Also follow this article which explained how to return json data in webservice, https://www.c-sharpcorner.com/UploadFile/ansh06031982/creating-web-services-in-net-which-returns-xml-and-json-dat/
0

how to return jsondata using webservice?

I alredy see this link via google