vb net sql结果为json没有按钮响应的ajax [英] vb net sql results to json for ajax without button response
本文介绍了vb net sql结果为json没有按钮响应的ajax的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
大家好，
我有一个问题会引发我很多关于开发JSON QUERY的问题。我的问题是如何发布一个自动加载的AJAX代码，而无需单击按钮从我创建的服务加载数据，如下代码：
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:
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>
</script>
</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>
推荐答案
.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，
成功： function （msg）{
try {
.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>输出ID< / strong>< ; / td> +
< td>< strong>输出消息< / 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< /强>< / TD>< / TR GT&;;
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 + < /表> ;
("#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 （错误）{
("#jsonDiv").html(t); } catch (err) {
这篇关于vb net sql结果为json没有按钮响应的ajax的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
