当前文件： DaDaNews/Admin/AdminNews.aspx.cs[3K，2009-6-12 11:38:34]，打开代码结构图

		            
  1using System;
  2using System.Collections;
  3using System.Configuration;
  4using System.Data;
  5using System.Data.SqlClient;
  6using System.Web;
  7using System.Web.Security;
  8using System.Web.UI;
  9using System.Web.UI.HtmlControls;
 10using System.Web.UI.WebControls;
 11using System.Web.UI.WebControls.WebParts;
 12
 13public partial class Admin_AddNews : System.Web.UI.Page
 14...{
 15    Db pn163 = new Db();
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        if (Session["Admin"] == null)
 19        ...{
 20            Response.Redirect("./Default.Aspx");
 21        }
 22        if (!IsPostBack)
 23        ...{
 24            this.labPage.Text = "1";
 25            this.contrlRepeater();
 26        }
 27    }
 28
 29    public void contrlRepeater()
 30    ...{
 31        SqlConnection Conn = new SqlConnection(pn163.strConn);
 32
 33        SqlDataAdapter Da = new SqlDataAdapter("select * from NewView order by id desc", Conn);
 34
 35        DataSet Ds = new DataSet();
 36
 37        Da.Fill(Ds, "NewView");
 38
 39        //分页 ^^
 40
 41        PagedDataSource pds = new PagedDataSource();
 42
 43        pds.DataSource = Ds.Tables["NewView"].DefaultView;
 44
 45        pds.AllowPaging = true;
 46
 47        pds.PageSize = 16;
 48
 49        pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
 50
 51        Repeater1.DataSource = pds;
 52
 53        LabCountPage.Text = pds.PageCount.ToString();
 54
 55        labPage.Text = (pds.CurrentPageIndex + 1).ToString();
 56
 57        this.lbtnpritPage.Enabled = true;
 58
 59        this.lbtnFirstPage.Enabled = true;
 60
 61        this.lbtnNextPage.Enabled = true;
 62
 63        this.lbtnDownPage.Enabled = true;
 64
 65        if (pds.CurrentPageIndex < 1)
 66        ...{
 67            this.lbtnpritPage.Enabled = false;
 68            this.lbtnFirstPage.Enabled = false;
 69        }
 70        if (pds.CurrentPageIndex == pds.PageCount - 1)
 71        ...{
 72            this.lbtnNextPage.Enabled = false;
 73            this.lbtnDownPage.Enabled = false;
 74        }
 75        Repeater1.DataBind();                                               
 76    }
 77
 78    protected void lbtnpritPage_Click(object sender, EventArgs e)
 79    ...{
 80        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
 81        this.contrlRepeater();
 82    }
 83    protected void lbtnFirstPage_Click(object sender, EventArgs e)
 84    ...{
 85        this.labPage.Text = "1";
 86        this.contrlRepeater();
 87    }
 88    protected void lbtnDownPage_Click(object sender, EventArgs e)
 89    ...{
 90        this.labPage.Text = this.LabCountPage.Text;
 91        this.contrlRepeater();
 92    }
 93
 94    protected void lbtnNextPage_Click(object sender, EventArgs e)
 95    ...{
 96        this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
 97        this.contrlRepeater();
 98    }
 99
100    protected void DelComm_Click(object sender, CommandEventArgs e)
101    ...{
102        int ID = Convert.ToInt32(e.CommandName);
103
104        SqlConnection Conn = new SqlConnection(pn163.strConn);
105
106        Conn.Open();
107
108        SqlCommand Cmd = new SqlCommand("delete from NewView where id=" + ID, Conn);
109
110
111        Cmd.ExecuteNonQuery();
112
113        Conn.Close();
114        Response.Redirect("./AdminNews.aspx");
115    }
116}
117