vb net sql results to json for ajax without button response

Question

0.00/5 (No votes)

See more:

, +

Hi Everyone,

I have a question that triggers me a lot to fix on developing a JSON QUERY. My question is how can I post an AJAX code in which it make an automatic load without clicking the button to load the data from the service I created as follows a code:

JavaScript

function testJson() {
        $.ajax({
            type: "POST",
            url: "http://112.206.229.182:91/JSON/Service.asmx/GetLatestText",
            data: JSON.stringify({passKey: "A4CA714AEBFA482A96D9091BABB4C51B", textID: 0}),
            contentType: "application/json; charset=utf-8",
            dataType: "json",
            success: function (msg) {
                try{
                    $("#jsonResponse").html(msg.d);
                    var dTbl = eval(msg.d);

                    var t = "<table border=1><tr>" +
                      "<td><strong>Output ID</strong></td>" +
                      "<td><strong>Output Msg</strong></td>" +
                      "<td><strong>ID</strong></td>" +
                      "<td><strong>HomeEventsText</strong></td>" +
                      "<td><strong>FontColor</strong></td>" +
                      "<td><strong>FontFamily</strong></td>" +
                      "<td><strong>FontSize</strong></td></tr>";

                    for (var i in dTbl) {
                        t = t + "<tr>" +
                            "<td> " + dTbl[i][0] + "</td>" +
                            "<td> " + dTbl[i][1] + "</td>" +
                            "<td> " + dTbl[i][2] + "</td>" +
                            "<td> " + dTbl[i][3] + "</td>" +
                            "<td> " + dTbl[i][4] + "</td>" +
                            "<td> " + dTbl[i][5] + "</td>" +
                            "<td> " + dTbl[i][6] + "</td>" +
                            "</tr> ";
                    }

                    t = t + " </table> ";

                    $("#jsonDiv").html(t);
                }
                catch (err) {
                    $("#jsonDiv").html(err.message);
                }
            },
            error: function (msg) {
                $("#jsonDiv").html("ERROR - " + msg);
            },
            failure: function(msg) {
                $("#jsonDiv").html("FAILED");
            }
        });
    };

</script>

HTML

</head>
<body>
    <p>
        <input id="testjson" type="button" value="Test JSON Call" onclick="testJson()" />
    </p>
    <br />
    <strong>Message Response</strong>
    <br />
    <div id="jsonResponse" style="display:block;"></div>
    <br />
    <strong>Processed Result</strong>
    <br />
    <div id="jsonDiv" style="display:block;"></div>
</body>
</html>

Posted 31-Jul-14 23:19pm

Member 10033107

Updated 31-Jul-14 23:27pm

Nirav Prabtani

v2

Add a Solution

3 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)

**Nirav Prabtani** · Answer 1 · 2014-07-31T23:29:00

Solution 1

Put your function testJson() in jQuery document.ready function

JavaScript

$(document).ready(function(){
   testJson();
});

or you can set that function onload of body

HTML

<body onload="testJson()">

</body>

Posted 31-Jul-14 23:29pm

Nirav Prabtani

Afzaal Ahmad Zeeshan · Answer 2 · 2014-08-02T12:21:00

The answer is simple, since you're handling this script on the onclick event it would always trigger that way. If you want it to happen as soon as the page loads you can try to add it to the body tag, like this

HTML

<body onload="testJson()"></body>

This would execute the very time when you will run the page to load it.

One more thing as Nirav has also mentioned would be to make sure the jQuery code is present inside the $(document).ready(function () { ... }); block. But I don't think that is a problem around since the code works in the click event.

Member 10033107 · Answer 3 · 2014-08-03T16:40:00

Solution 3

Thanks For the response Guys

Its Already Working.

Posted 3-Aug-14 16:40pm

Member 10033107

vb net sql results to json for ajax without button response

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us