3层学习 更好的使用json

1. DAL sql执行  

  最后格式 DataTable

        public DataTable SelAdmin() {
            DataTable dt = SqlHelper.ExecuteDataTable("select * from A_Admin");
            return dt;
        }

2. BLL 调用并执行 DataTable convert Json

 最后格式Json

        public static string SelAdmin()
        {
            A_AdminDAL ad = new A_AdminDAL();
            string msg = DataConvertJson.DataTableToJson("Table", ad.SelAdmin());
            return msg;
        }

DataConvertJson.DataTableToJson("Table", ad.SelAdmin());// DataTable 转换为 Json

3 .ashx

 最后  contex.response.wreint(string);//直接将json打印出来

                else if (Class == "all")
                {
                    context.Response.Write(A_AdminBLL.SelAdmin());
                }

4.ajax调用

function GetAdminAll() {
    alert(1);
    $.ajax({
        url: "/Json/New.ashx",
        dataType: "json",
        cache: false,
        data: "class=all",
        type: "Post",
        success: function (data) {
            alert("test " + data);
            var msg = "";
            for (var i = 0, length = data.Table.length; i < length; i++)
                msg += "<tr><td>" + data.Table[i].UserId + "</td><td>" + data.Table[i].UserCard + "</td><td>" + data.Table[i].UserPw + "</td><td>" + data.Table[i].UserLv + "</td><td><td></tr>";
            $("tbody").html(msg);
        }
    })
}