How to return json data when filled the webservice page

Question

0.00/5 (No votes)

See more:

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

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;
        }
    }
}

x

I add this line for return the json data

[ScriptMethod(ResponseFormat = ResponseFormat.Json)]

when I inserted the data using webservice and click the Invoke Button of the webservice page then data is not display?

What I have tried:

I add this line for return the json data but json data is not displayed

[ScriptMethod(ResponseFormat = ResponseFormat.Json)

Posted 19-May-20 1:01am

Member 14836995

Updated 19-May-20 5:11am

Add a Solution

Comments

Richard Deeming 19-May-20 8:16am

You're storing passwords in plain text. Don't do that.

Secure Password Authentication Explained Simply[^]
Salted Password Hashing - Doing it Right[^]

2 solutions

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)

MadMyche · Answer 1 · 2020-05-19T01:31:00

Solution 1

The method that you have declared is setup to return a string.
The method also defines a string called data, and is populated as an empty string.
The end of routine does a return of this same data variable.

The problem is... data is never defined as anything but an empty string.

Posted 19-May-20 1:31am

MadMyche

Comments

Member 14836995 19-May-20 8:28am

hi MadMyche

string data = fname + mname + lname + emailid + password + contactno + hobby +
address + countrycodenum;

watch window

data "rajumakvanadineshrahulaxay@gmail.com123451234567890cricketsuratuzbekistan" string

but issue is not return the proper data

MadMyche 19-May-20 8:44am

That is the data that you are passing into the method; and not the value of the data variable you have declared, defined, and returned within it

string data = "";  // line  9

return data;       // line 35

Member 14836995 19-May-20 8:54am

Hi MadMyche

can u give any solution for that and how to solve this issue

I want to convert string data object to json data object

MadMyche 19-May-20 10:55am

I would do this pretty close to an MVC structure:
1. Create a Student class with the properties.
2. Populate this class with incoming values to create object instance.
3. Save the object to the DB
4. Use the JSON Serializer to return the object

F-ES Sitecore · Answer 2 · 2020-05-19T05:12:00

C#

[System.Web.Script.Services.ScriptService]
public class WebService1 : WebService
{
    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public void InsertData(string fname, string mname, string lname, string emailid, string password, string contactno, string hobby, string address, string countrycodenum)
    {
        // create anonymous type with the data
        var data = new { fname, mname, lname, emailid, password, contactno, hobby, address, countrycodenum };

        // serialise that data to JSON
        string json = (new System.Web.Script.Serialization.JavaScriptSerializer()).Serialize(data);

        // write it to the response stream
        Context.Response.Write(json);
    }
}