how to call web service from javascript (ajax)

Question

i have 1 project webservice and 1 project web asp.net i want to insert data by json(ajax) i tested file service by code behind and it good, have error with code js file WebService1:

public bool HelloWorld(student obj) {
    SqlConnection cnn = new SqlConnection("Data Source=PHAMHOP-LAPTOP\\SQLEXPRESS;Initial Catalog=qlsv;Integrated Security=True");
    cnn.Open();
    SqlCommand cmd = new SqlCommand("insert into sinhvien(name,age) values(@name,@age)", cnn);
    cmd.Parameters.AddWithValue("name", obj.name);
    cmd.Parameters.AddWithValue("age", obj.age);
    int row = cmd.ExecuteNonQuery();
    if (row == 1){
        return true;
    } else {
        return false;
    }
}

file aspx:

<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
    function add() {
        $.ajax({
            type: "POST",
            url: "http://localhost:51097/Service1.asmx/HelloWorld",
            data: "{'id':'1' ,'name': 'Amit', 'age': '97'}",
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (msg) {
                alert("ok");
            }
        });
    }
</script>
<body>
    <input type='Button' value='gui' OnClick='add()'/>
</body>

It does not work.

try removing contentType: "application/json; charset=utf-8", dataType: "json", — rrk
– rrk, Commented Aug 6, 2015 at 5:00
It does not work will not help. Post the actual error message you are getting from the browser console. — Rahul Singh
– Rahul Singh, Commented Aug 6, 2015 at 5:17

rrk · Accepted Answer · 2016-02-21 14:51:24Z

1

Since the returned data is not JSON contentType: "application/json; charset=utf-8", dataType: "json", is not needed and the data option does not need to be a string. Pass it as an object.

Try this

function add() {
    $.ajax({
        type: "POST",
        url: "http://localhost:51097/Service1.asmx/HelloWorld",
        contentType: "application/json; charset=utf-8",
        dataType: "json",
        data: {
            id: 1,
            name: 'Amit',
            age: 97
        },
        success: function (msg) {
            alert("ok");
        }
    });
}

edited Feb 21, 2016 at 14:51

answered Aug 6, 2015 at 5:05

rrk

15.9k4 gold badges32 silver badges49 bronze badges

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

1 Comment

ZedBee Over a year ago

what does 'contentType' has to do with returned data? Isn't it to specify the data that is sent to the server rather than returned from the server?

Kris · Accepted Answer · 2015-08-06 05:41:15Z

0

Alternatively, you could try passing the JSON as a string parameter instead of as a student and deserialising it yourself using Newtonsoft or System.Web.Script.Serialization.JavaScriptSerializer.

bool HelloWorld(string obj)

instead of

bool HelloWorld(student obj)

edited Aug 6, 2015 at 5:41

answered Aug 6, 2015 at 5:03

Kris

1,39011 silver badges16 bronze badges

1 Comment

Jaromanda X Over a year ago

try passing the JSON as a string - JSON is a string

Collectives™ on Stack Overflow

how to call web service from javascript (ajax)

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related