52,798
社区成员
发帖
与我相关
我的任务
分享
<head runat="server">
<title></title>
<script src="js/jquery-1.4.2.js" type="text/javascript"></script>
<script language="javascript" type="text/javascript">
//表格的行数
var $index = 20;
//返回的行数
var $ICount = 0;
$(document).ready(function() {
CreateTable();
BindTable();
});
function CreateTable() {
$TableStr = "<table width='100%'>";
for (i = 0; i < $index; i++) {
$TableStr += "<tr id='trs" + i + "'><td></td><td></td><td></td><td></td></tr>";
}
$TableStr += "</table>";
$("#LoadTable").html($TableStr);
$TableStr = null;
}
function BindTable() {
$.getJSON("json_Page.ashx?rid=" + Math.random(), ss);
}
function ss(data) {
$.each(data, EachData);
for (i = 0; i < $index; i++) {
$("#trs" + i).css("display", "block");
}
for (i = $ICount; i < $index; i++) {
$("#trs" + i).css("display", "none");
}
}
function EachData(i, n) {
if ($.trim($("#trs" + i + " td:eq(0)").html()) != $.trim(n.SBBH)) {
$("#trs" + i + " td:eq(0)").html($.trim(n.SBBH));
}
if ($.trim($("#trs" + i + " td:eq(1)").html()) != $.trim(n.DLMC)) {
$("#trs" + i + " td:eq(1)").html($.trim(n.DLMC));
}
if ($.trim($("#trs" + i + " td:eq(2)").html()) != $.trim(n.HPHM)) {
$("#trs" + i + " td:eq(2)").html($.trim(n.HPHM));
}
if ($.trim($("#trs" + i + " td:eq(3)").html()) != $.trim(n.JGSJ)) {
$("#trs" + i + " td:eq(3)").html($.trim(n.JGSJ));
}
$ICount = i + 1;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<input id="Button1" type="button" value="刷新" onclick="BindTable()" />
<div id="LoadTable">
</div>
</form>
</body>
private void GetData(HttpContext context)
{
SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=123456;database=New_ITS");
conn.Open();
SqlCommand cmd = new SqlCommand("select top 20 * from carinfo", conn);
SqlDataReader dr = cmd.ExecuteReader();
IList<Entity> carinfo = new List<Entity>();
while (dr.Read())
{
Entity entity = new Entity();
entity.SBBH = dr["SBBH"].ToString();
entity.DLMC = dr["DLMC"].ToString();
entity.HPHM = dr["HPYS"].ToString();
entity.JGSJ = dr["JGSJ"].ToString();
carinfo.Add(entity);
}
dr.Close();
dr.Dispose();
conn.Close();
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
context.Response.Write(js.Serialize(carinfo));
context.Response.End();
}
function BindTable() {
$.getJSON("json_Page.ashx?rid=" + Math.random(), ss);
}
这里的ss有没有死循环,bindTable有没有被事件嵌套执行