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);
}
})
}