string g = "select count(*) from News";
AspNetPager1.RecordCount = Convert.ToInt32(SqlHelper.ExecuteScalar(con, g));
OleDbCommand cmd = new OleDbCommand("select * from News order by GetTime desc", con);
cmd.CommandType = CommandType.Text;
OleDbDataAdapter Sdr = new OleDbDataAdapter();
Sdr.SelectCommand = cmd;
DataSet odr = new DataSet();
Sdr.Fill(odr, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "article");
this.DataList1.DataSource = odr.Tables["article"];
this.DataList1.DataBind();
//动态设置用户自定义文本内容 以下文本是否生效,要设置ShowCustomInfoSection属性
AspNetPager1.CustomInfoText = "记录总数:<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";
AspNetPager1.CustomInfoText += " 总页数:<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";
AspNetPager1.CustomInfoText += " 当前页:<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
Sdr.Dispose();
con.Close();
转载于:https://www.cnblogs.com/epwqgdnvrhok/archive/2008/08/13/1266536.html