C#-DataTable分页代码
生活随笔
收集整理的這篇文章主要介紹了
C#-DataTable分页代码
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
/// <summary>/// DataTable分頁并取出指定頁碼的數據/// </summary>/// <param name="dtAll">DataTable</param>/// <param name="pageNo">頁碼,注意:從1開始</param>/// <param name="pageSize">每頁條數</param>/// <returns>指定頁碼的DataTable數據</returns>private DataTable getOnePageTable(DataTable dtAll, int pageNo, int pageSize){var totalCount = dtAll.Rows.Count;var totalPage = getTotalPage(totalCount, pageSize);var currentPage = pageNo;currentPage = (currentPage > totalPage ? totalPage : currentPage);//如果PageNo過大,則較正PageNo=PageCountcurrentPage = (currentPage <= 0 ? 1 : currentPage);//如果PageNo<=0,則改為首頁//----克隆表結構到新表var onePageTable = dtAll.Clone();//----取出1頁數據到新表var rowBegin = (currentPage - 1) * pageSize;var rowEnd = currentPage * pageSize;rowEnd = (rowEnd > totalCount ? totalCount : rowEnd);for (var i = rowBegin; i <= rowEnd - 1; i++){var newRow = onePageTable.NewRow();var oldRow = dtAll.Rows[i];foreach (DataColumn column in dtAll.Columns){newRow[column.ColumnName] = oldRow[column.ColumnName];}onePageTable.Rows.Add(newRow);}return onePageTable;}/// <summary>/// 返回分頁后的總頁數/// </summary>/// <param name="totalCount">總記錄條數</param>/// <param name="pageSize">每頁顯示條數</param>/// <returns>總頁數</returns>public int getTotalPage(int totalCount, int pageSize){var totalPage = (totalCount / pageSize) + (totalCount % pageSize > 0 ? 1 : 0);return totalPage;}
?
與50位技術專家面對面20年技術見證,附贈技術全景圖總結
以上是生活随笔為你收集整理的C#-DataTable分页代码的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: Effective C++: noexc
- 下一篇: 本地安装gem install --lo