About Datelist One-line Binding Multiple Data Pagments (1) CS file

xiaoxiao2021-03-06 49

.cs page protected System.Web.UI.WebControls.DataList DataList2; int pageSize, recordCount, pageCount, currentPage; protected System.Web.UI.WebControls.Label lbRecordCount; protected System.Web.UI.WebControls.Label lbCurrentPage; protected System .Web.UI.WebControls.Label lbPageCount; protected System.Web.UI.WebControls.LinkButton butPrev; protected System.Web.UI.WebControls.LinkButton butNext; protected System.Web.UI.WebControls.LinkButton LinkButton2; protected System.Web .UI.WebControls.LinkButton LinkButton1; protected System.Web.UI.WebControls.DropDownList dlsPageIndex; private void Page_Load (object sender, System.EventArgs e) {// Put user code to initialize the page here pageSize = 18; // Total number of data

IF (! page.ispostback) {currentpage = 0; // Initialization The current page is page 0 ViewState ["currentpage"] = 0;

Recordcount = CalculateRecord (); // How many record calls method ViewState ["RecordCount"] = RecordCount; if (RecordCount% PageSize == 0) // Calculate how many pages {pageCount = (Recordcount / Pagesize);} else {PageCount = (RecordCount / Pagesize) 1;} ViewState ["PageCount"] = pageCount; initdls (); binddata ();}}

Public int CalculateRecord () // Method for calculating the number of pages {INT Count; dbmanage dbs = new dbmanage (); sqlConnection conn; conn = dbs.getConnection (); string countstr = "Select Count (*) as total from hyUser Where Fag = 'Reviewed' ";

Sqlcommand Comm = New SQLCOMMAND (CountStr, Conn); SqlDataReader DR = Comm.executeReader (); if (Dr.Read ()) {Count = Int.Parse (DR ["Total"]. TOSTRING ();} else { COUNT = 0;} conn.close (); tr.close (); return count;}

public void BindData () {int startPage; dbmanage dbs = new dbmanage (); SqlConnection conn; conn = dbs.GetConnection (); startPage = currentPage * pageSize; string selectStr = "select coname, userid, addtime, fag from hyuser where fag = 'Review' Order By Addtime Desc "; DataSet DS = New DataSet (); SqlDataAdapter Da = New SqlDataAdapter (SelectStr, Conn); Da.Fill (DS, StartPage, Pagesize," Message "); Datalist2.DataSource = DS DataList2.Datamember = "message"; DataList2.Database (); lbcurrentpage.text = (int.pars "]. TOSTRING ()) 1) .tostring (); lbpagecount.text = (pagecount) .Tostring (); lbrecordcount.text = RecordCount.toString (); dlspageindex.selectedIndIndex = CurrentPage; conn.close ();

#Region Web Form Designer Generated Code Override Protected Void OnNit (Eventargs E) {// // Codegen: This call is necessary for the ASP.NET Web Form Designer. // InitializeComponent (); base.onit (e);} ///

/// Designer Supports the required method - Do not use the code editor to modify the // / this method. /// private void InitializeComponent () {this.butPrev.Click = new System.EventHandler (this.butPrev_Click); this.butNext.Click = new System.EventHandler (this.butNext_Click); this.LinkButton1 .Click = new System.EventHandler (this.LinkButton1_Click); this.LinkButton2.Click = new System.EventHandler (this.LinkButton2_Click); this.dlsPageIndex.SelectedIndexChanged = new System.EventHandler (this.dlsPageIndex_SelectedIndexChanged); this. Load = new system.eventhandler (this.page_load);

} #Endregion

private void butNext_Click (object sender, System.EventArgs e) {currentPage = (int) ViewState [ "CurrentPage"]; pageCount = (int) ViewState [ "PageCount"]; recordCount = (int) ViewState [ "RecordCount"]; if (CurrentPage

private void butPrev_Click (object sender, System.EventArgs e) {currentPage = (int) ViewState [ "CurrentPage"]; pageCount = (int) ViewState [ "PageCount"]; recordCount = (int) ViewState [ "RecordCount"];

IF (CurrentPage> 0) CurrentPage ---; ViewState ["CurrentPage"] = CurrentPage; binddata ();

Public voidin () {for (int i = 1; i <= (pagecount); i ) {dlspageIndex.Items.Add (New ListItem ", (i-1) .tostring () ));}} private void dlsPageIndex_SelectedIndexChanged (object sender, System.EventArgs e) {currentPage = (int) ViewState [ "CurrentPage"]; pageCount = (int) ViewState [ "PageCount"]; recordCount = (int) ViewState [ " RecordCount "]; currentPage = int.Parse (dlsPageIndex.SelectedItem.Value); ViewState [" CurrentPage "] = currentPage; BindData ();} private void LinkButton1_Click (object sender, System.EventArgs e) {currentPage = (int) ViewState ["Currentpage"]; pageCount = (int) ViewState ["pagecount"]; recordcount = (int) ViewState ["RecordCount"];

ViewState ["CurrentPage"] = 0; binddata ();

private void LinkButton2_Click (object sender, System.EventArgs e) {currentPage = (int) ViewState [ "CurrentPage"]; pageCount = (int) ViewState [ "PageCount"]; recordCount = (int) ViewState [ "RecordCount"]; Page .Response.write (ViewState ["PageCount"]); ViewState ["currentpage"] = PageCount-1; binddata ();} ------------------- -------------------------------------------------- ----------------------------------------------

转载请注明原文地址:https://www.9cbs.com/read-83278.html

9cbs

New Post(0)