没有显示超过1427的记录 [英] Not showing records more than 1427

问题描述

我正在尝试使用JSON和C＃.net将值从数据库加载到html表。我没有显示超过1427的记录并显示错误Unexpected token<。

I am trying to load values from database to html table using JSON and C#.net. I not showing the records more than 1427 and showing the error "Unexpected token <".

//JSON
--------------------------------


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

function bindData() {

    $.ajax({
        type: "POST",
        url: "MyTestForm.aspx/getData",
        data: "{}",
        contentType: "application/json;charset=utf-8",
        datatype: "jsondata",
        async: "true",
        success: function (response) {

            var msg = eval('(' + response.d + ')');
           
            if ($('#tblResult').length != 0) {
                $("#tblResult").remove();
            }
          
            var table = "<table class="tblResult" id="tblResult"><thead><table><tbody><tr><th>Name</th><th>Address</th><th>Age</th></tr></tbody></table></thead> <tbody>";
           
            for (var i = 0; i <= (msg.length - 1) ; i++) {
                var row = "<tr>";
                row += '<td>' + msg[i].Name + '</td>';
                row += '<td>' + msg[i].Address + '</td>';
                row += '<td>' + msg[i].Age + '</td>';
              
                row += '</tr>';
                table += row;

            }
            
            table += "</tbody></table>";
            $('#divData').html(table);
            $('#divData').slideDown("slow");
            
        },
        error: function (response) {
            alert(response.status + ' ' + response.statusText);
        }
    });
}

//C#
---------------------------------------------------------

 [WebMethod]
    public static string getData()
    {
        string data = string.Empty;
        try
        {
            using (MyTestDatabaseEntities context = new MyTestDatabaseEntities())
            {
                var obj = (from r in context.MstNewTests select r).ToList();
                JavaScriptSerializer serializer = new JavaScriptSerializer();
                data = serializer.Serialize(obj);
            }
            return data;
        }
        catch
        {
            return data;
        }
    }

推荐答案

（ document ）.ready（ function （）{
bindData（）;
}）;

function bindData（）{

(document).ready(function () { bindData(); }); function bindData() {

.ajax（{
type： POST，
url： MyTestForm.aspx / getData，
data： {}，
contentType： application / json; charset = utf- 8，
数据类型： jsondata，
async ： true，
成功： function （回复）{

var msg = eval （< span class =code-string>' （' + response.d + ' ）'）;

if （

.ajax({ type: "POST", url: "MyTestForm.aspx/getData", data: "{}", contentType: "application/json;charset=utf-8", datatype: "jsondata", async: "true", success: function (response) { var msg = eval('(' + response.d + ')'); if (

（'' ＃tblResult'）。length！= 0 ）{

('#tblResult').length != 0) {

这篇关于没有显示超过1427的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！