1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11
12public partial class admin_Default2 : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16
17        if (!IsPostBack)
18        ...{
19            binddr();
20        }
21    }
22
23    string cid = "";
24    void binddr()
25    ...{
26
27        //string sql = "select * from Sp_user ";
28
29        DataSet ds = Sp.SQLServerDAL.DbHelperSQL.Query("select * from Sp_user order by id desc");
30
31        DataView dv = ds.Tables[0].DefaultView;
32        PagedDataSource pds = new PagedDataSource();
33
34        AspNetPager1.RecordCount = dv.Count;
35        pds.DataSource = dv;
36        pds.AllowPaging = true;
37        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
38        pds.PageSize = AspNetPager1.PageSize;
39
40        this.GridView1.DataSource = pds;
41        this.GridView1.DataBind();
42    }
43    protected void AspNetPager1_PageChanged(object src, EventArgs e)
44    ...{
45        binddr();
46    }
47
48}
49