asp.net异步猎取datatable并显示的实现方法_

1、异步猎取datatable并显示的实现方法_ 本文讲解并描述了异步猎取datatable并显示的实现方法。分享给大家供大家参考，具体如下： 上面就是结果，前台代码如下： % Page Language=C# AutoEventWireup=true CodeFile=MethodOne.aspx.cs Inherits=_Default % !DOCTYPE html PUBLIC -/W3C/DTD XHTML 1.0 Transitional/EN l1/DTD/xhtml1-transitional.dtd html xmlns=l head runat=server title/tit

2、le link href=swcss.css rel=stylesheet type=text/css / link href=TableZB.css rel=stylesheet type=text/css / script src=js-datagrid/scripts/PagerView.js type=text/javascript/script link href=js-datagrid/style.css rel=stylesheet type=text/css / script src=jquery-1.4.1.min.js type=text/javascript/script

3、 script type=text/javascript var currentpage = 1; $(document).ready(function() $.get(Handler.ashx?flag=dataindex= + currentpage, function(data) $(#sjxs).append(data); ); $.get(Handler.ashx?flag=count, function(count) var pager = new PagerView(pager); pager.itemCount = count; pager.size = 5; pager.on

4、click = function(index) currentpage = index; $.get(Handler.ashx?flag=dataindex= + index, function(data) $(#sjxs tr).each(function(m) $(#add + m).remove(); ); $(#sjxs).append(data); ); ; pager.render(); ); ); /script /head body form id=form1 runat=server fieldset style=width: 98%; border: solid 1px #

5、EDF7DC; class=fileset_style legend class=leg_style查询结果/legend %-div style=overflow:scroll;width:100%;height:100%-% table border=1 cellpadding=0 cellspacing=0 width=100% align=center id=sjxs class=TableStyleZB tr class=trTitle td colspan=5当前发票库存状况/td td colspan=4购买后一年(含)以上未验旧用法状况/td td/td /tr tr clas

6、s=trTitle td管理机关/td td合计/td td机打发票/td td手工发票/td td冠名发票/td td其他/td td正常户/td td占库存户数的比率/td td非正常户/td td证件失效户/td /tr tr class=trTitle td0/td td1/td td2/td td3/td td4/td td5/td td6/td td7=6/1/td td8/td td9/td /tr /table %-/div-% /fieldset div id=pager/div div id=info/div /form /body /html 处理页面程序如下： % We

7、bHandler Language=C# Class=Handler % using System; using System.Web; using System.Data; using System.Data.SqlClient; using System.Text; public class Handler : IHttpHandler public void ProcessRequest (HttpContext context) context.Response.ContentType = text/plain; if (context.Request.QueryStringflag.

8、Equals(data) context.Response.Write(GetResult(5,Int32.Parse(context.Request.QueryStringindex); if (context.Request.QueryStringflag.Equals(count) context.Response.Write(getCount(); private string GetResult() DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(System.Configur

9、ation.ConfigurationManager.AppSettingsconn) conn.Open(); string sql = SELECT * FROM TestBlog ; SqlDataAdapter sda = new SqlDataAdapter(sql, conn); sda.Fill(dt); int rLen = dt.Rows.Count; int cLen = dt.Columns.Count; StringBuilder sb = new StringBuilder(); for (int j = 0; j rLen; j+) sb.Append(tr); f

10、or (int i = 0; i cLen; i+) sb.Append(td); sb.Append(dt.Rowsji.ToString(); sb.Append(/td); sb.Append(/tr); return sb.ToString(); private string GetResult(int pagecount,int currentpage) DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationMana

11、ger.AppSettingsconn) conn.Open(); string sql = SELECT TOP +pagecount+ * FROM TestBlog tb WHERE ydid NOT IN (SELECT TOP +pagecount*(currentpage-1)+ ydid FROM TestBlog tb2) ; SqlDataAdapter sda = new SqlDataAdapter(sql,conn); sda.Fill(dt); int rLen = dt.Rows.Count; int cLen = dt.Columns.Count; StringB

12、uilder sb = new StringBuilder(); for (int j = 0; j rLen; j+) sb.Append(tr id=add+j+); for (int i = 0; i cLen; i+) sb.Append(td); sb.Append(dt.Rowsji.ToString(); sb.Append(/td); sb.Append(/tr); return sb.ToString(); private string getCount() DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettingsconn) conn.Open(); string sql = select count(*) from testblog; SqlDataAdapter sda = new