国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 學(xué)院 > 開(kāi)發(fā)設(shè)計(jì) > 正文

Datatable paging,Repeater with Paging

2019-11-15 02:31:52
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

Datatable paging,Repeater with Paging

/// <summary>    /// 塗聚文    /// 20140225    /// </summary>    public partial class DatatablePage : System.Web.UI.Page    {        /// <summary>        /// 測(cè)試 分頁(yè)數(shù)據(jù)        /// </summary>        DataTable pageDt;        /// <summary>        ///         /// </summary>        public void geovinduDt()        {            pageDt = new DataTable();            pageDt.Columns.Add("id", typeof(int));            pageDt.Columns.Add("ddno", typeof(string));            pageDt.Columns.Add("dd", typeof(string));            //dtyhdd.Rows.Add("1", "n1");            //dtyhdd.Rows.Add("2", "n2");            for (int i = 1; i <= 31; i++)            {                //保存到內(nèi)存表中                DataRow tr = this.pageDt.NewRow();                tr["id"] = i;                tr["ddno"] = i.ToString();                tr["dd"] = i.ToString() + "內(nèi)容";                pageDt.Rows.Add(tr);            }        }        /// <summary>        /// 隱患地點(diǎn)共分多少頁(yè)        /// </summary>        int verypage = 0;        /// <summary>        /// 隱患當(dāng)前頁(yè)        /// </summary>        int currentPage = 0;        /// <summary>        /// 每頁(yè)顯示多少數(shù)據(jù)        /// </summary>        int PageSize = 1;        /// <summary>        ///         /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        PRotected void Page_Load(object sender, EventArgs e)        {                                    if (!IsPostBack)            {                if (!string.IsNullOrEmpty(Request.QueryString["page"]))                {                    currentPage = int.Parse(Request.QueryString["page"]);                }                currentPage++;                this.TextBox1.Text = currentPage.ToString();                //【初始化數(shù)據(jù)】                geovinduDt();                //【執(zhí)行分頁(yè)顯示】                //每次顯示10條數(shù)據(jù) 需要多少次                verypage = pageDt.Rows.Count / 1;                //是否有余數(shù)                int numys = pageDt.Rows.Count % 1;                if (numys > 0)                {                    currentPage++;                }                //comyhdd.Items.Clear();                if (currentPage >= pageDt.Rows.Count)                {                    Button1.Enabled = false;                     return;                }                DataRow[] mMatches = pageDt.Select("(id=" + currentPage + ")");                //DataRow matches = new DataRow();                string strName = mMatches[0]["dd"].ToString();                DataSet pDS = new System.Data.DataSet();                System.Data.DataTable mDT = pageDt.Clone();                mDT.Clear();                //mDT.TableName = mTableName;                //mDT = mDT.Clone();                for (int i = 0; i < mMatches.Length; i++)                {                    mDT.Rows.Add(mMatches[i].ItemArray);                }                pDS.Tables.Add(mDT);                //1                Repeater1.DataSource = GetPagedTable(pageDt, currentPage, PageSize);                Repeater1.DataBind();                //2                //Repeater1.DataSource = pDS;                //Repeater1.DataBind();                this.TextBox1.Text = strName;                //Repeater1.DataSource = GetPagedTable(pageDt, yhdddqi, PageSize);                //Repeater1.DataBind();                this.Label1.Text = currentPage.ToString() + "/" + verypage;                            }        }        /// <summary>        ///         /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        protected void Button1_Click(object sender, EventArgs e)        {            verypage = 1;              //下一頁(yè)            if (!string.IsNullOrEmpty(Request.QueryString["page"]))            {                currentPage = int.Parse(Request.QueryString["page"]);            }            currentPage++;            geovinduDt();            if (currentPage >= pageDt.Rows.Count)            {                Button1.Enabled = false;                 return;            }            DataRow[] mMatches = pageDt.Select("(id=" + currentPage + ")");            //DataRow matches = new DataRow();            string strName = mMatches[0]["dd"].ToString();            this.TextBox1.Text = strName;            string answer = string.Empty;            if (CheckBoxA.Checked == true)            {                answer = "A";            }            if (CheckBoxB.Checked == true)            {                if (!string.IsNullOrEmpty(answer))                {                    answer = answer + "," + "B";                }                else                {                    answer = "B";                }            }            if (CheckBoxC.Checked == true)            {                if (!string.IsNullOrEmpty(answer))                {                    answer = answer + "," + "C";                }                else                {                    answer = "C";                }            }            if (CheckBoxD.Checked == true)            {                if (!string.IsNullOrEmpty(answer))                {                    answer = answer + "," + "D";                }                else                {                    answer = "D";                }            }            Jscript.Alert(answer);            this.Label1.Text = currentPage.ToString() + "/" + verypage;            Response.Redirect("DatatablePage.aspx?page=" + (currentPage) + "&name=" + strName);                        }        /// <summary>        /// DataTable分頁(yè)        /// </summary>        /// <param name="dt">DataTable</param>        /// <param name="PageIndex">頁(yè)索引,注意:從1開(kāi)始</param>        /// <param name="PageSize">每頁(yè)大小</param>        /// <returns></returns>        public static DataTable GetPagedTable(DataTable dt, int currentPageIndex, int pageSize)        {            //1            //判斷當(dāng)前索引            if (currentPageIndex == 0)                return dt;            //從數(shù)據(jù)集合拷貝數(shù)據(jù)            DataTable newdt = dt.Copy();            //數(shù)據(jù)清空            newdt.Clear();            //開(kāi)始數(shù)據(jù)索引 = 當(dāng)前頁(yè)-1 x 每頁(yè)大小            int rowbegin = (currentPageIndex - 1) * pageSize;            //結(jié)束數(shù)據(jù)索引 = 當(dāng)前頁(yè) x 每頁(yè)大小            int rowend = currentPageIndex * pageSize;            //開(kāi)始數(shù)據(jù)索引 大于等于 當(dāng)前數(shù)據(jù)集合大小            if (rowbegin >= dt.Rows.Count)                return newdt;            //結(jié)束數(shù)據(jù)索引 大于 當(dāng)前數(shù)據(jù)集合大小            if (rowend > dt.Rows.Count)                rowend = dt.Rows.Count;            //遍歷數(shù)據(jù)            for (int i = rowbegin; i <= rowend - 1; i++)            {                DataRow newdr = newdt.NewRow();                DataRow dr = dt.Rows[i];                foreach (DataColumn column in dt.Columns)                {                    newdr[column.ColumnName] = dr[column.ColumnName];                }                newdt.Rows.Add(newdr);            }            return newdt;            //2            //if (currentPageIndex == 0)            //{            //return dt;            //}            //DataTable newdt = dt.Clone();// dt.Copy();                         //int rowbegin = (currentPageIndex - 1) * pageSize;//當(dāng)前頁(yè)的第一條數(shù)據(jù)在dt中的位置            //int rowend = currentPageIndex * pageSize;//當(dāng)前頁(yè)的最后一條數(shù)據(jù)在dt中的位置                         //if (rowbegin >= dt.Rows.Count)            //{            //    return newdt;            //}                         //if (rowend > dt.Rows.Count)            //{            //    rowend = dt.Rows.Count;            //}                         //DataView dv = dt.DefaultView;            //for (int i = rowbegin; i <= rowend - 1; i++)            //{            //    newdt.ImportRow(dv[i].Row);            //}                         //return newdt;                    }    }

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DatatablePage.aspx.cs" Inherits="ShoppingDeals.Admin.VipHKExamSystem.DatatablePage" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 洛浦县| 肥城市| 尉氏县| 台东市| 永泰县| 肥乡县| 甘南县| 平乐县| 伊金霍洛旗| 上犹县| 嘉义县| 新昌县| 荔浦县| 海丰县| 玉林市| 合江县| 巴中市| 辰溪县| 墨竹工卡县| 十堰市| 临泉县| 宁波市| 安康市| 珠海市| 东台市| 库尔勒市| 深圳市| 永康市| 内黄县| 麻栗坡县| 闻喜县| 昭觉县| 锦州市| 资源县| 新龙县| 巴塘县| 阳高县| 禄劝| 固始县| 萝北县| 桦甸市|