xxxx18一60岁hd中国/日韩女同互慰一区二区/西西人体扒开双腿无遮挡/日韩欧美黄色一级片 - 色护士精品影院www

  • 大小: 218KB
    文件類型: .zip
    金幣: 2
    下載: 0 次
    發布日期: 2021-05-20
  • 語言: C#
  • 標簽: Datagridview??

資源簡介

C#開發的Datagridview分頁控件源碼,采用的真分頁非存儲過程方式。支持每頁顯示條數,頁跳轉,當前頁和全部頁導出Excel功能。 使用方法。將本控件源碼導入自己的新建項目中,整個項目編譯一次后,工具箱會自動生成一個第三方控件名稱叫DataPager。在winForm上的datagridview控件下拖入本控件,設置好每頁顯示的最大記錄條數(默認為50條記錄)即可。代碼中加入以下代碼 this.dataPager1.RelationControl(this.Dgv);//本控件并聯的datagridview控件名。 this.dataPager1.DataSource = ds.Tables[0];//本控件的數據源.

資源截圖

代碼片段和文件信息

using?System;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.IO;
using?System.Text;
using?System.Text.Regularexpressions;
using?System.Windows.Forms;

namespace?DataGridViewPagerControl
{
????#region?定義按鈕單擊事件的委托
????//【1】定義按鈕單擊事件的“委托”(參數)
????public?delegate?void?PagerQueryDelegate(string?sqlString);
????public?delegate?void?DataSetToExcel(string?sqlString);
????#endregion
????[ToolboxBitmap(t:?typeof(PagerControl)?name:?“App.ico“)]
????public?partial?class?PagerControl?:?UserControl
????{
????????#region?委托事件
????????//【2】定義分頁按鈕“單擊事件”(實際調用使用的方法)
????????public?event?PagerQueryDelegate?ExecQueryEventHandler;
????????public?event?DataSetToExcel?ExecDataSetToExcelEventHandler;
????????#endregion

????????#region?參數
????????private?int?_recordCount;//記錄總數
????????private?int?_pageSize;//每頁顯示多少條記錄
????????private?int?_maxRecordPerPage?=?1000;//每頁最多顯示記錄數不能超過1000條
????????private?int?_pageCount;//分頁總數
????????private?int?_currentPagerIndex;//當前頁碼

????????private?string?_tableName;//要查詢的表或視圖
????????private?string[]?_filedNameArray;//需要顯示的字段名數組
????????private?string?_keyword;//主鍵或查詢關鍵字
????????private?string?_whereString;//查詢條件
????????private?string?_sortString;//排序條件
????????#endregion

????????#region?屬性
????????///?
????????///?記錄總數
????????///?

????????public?int?RecordCount
????????{
????????????get?{?return?_recordCount;?}
????????????set?{?_recordCount?=?value;?}
????????}
????????[BrowsableAttribute(true)?DefaultValue(“50“)?Description(“設置每頁顯示的記錄條數“)?Category(“數據“)]
????????///?
????????///?分頁大小每頁顯示多少條記錄
????????///?

????????public?int?PageSize
????????{
????????????get?{?return?_pageSize;?}
????????????set
????????????{
????????????????_pageSize?=?value;
????????????????if?(_pageSize?!=?0)
????????????????{
????????????????????this.CmbPageSize.Text?=?_pageSize.ToString();
????????????????}
????????????????else
????????????????{
????????????????????this.CmbPageSize.Text?=?“50“;
????????????????????_pageSize?=?50;
????????????????}
????????????????this.Invalidate();
????????????}
????????}
????????[BrowsableAttribute(true)?DefaultValue(“1000“)?Description(“設置每頁可顯示記錄的最大值“)?Category(“數據“)]
????????///?
????????///?每頁最多顯示記錄數不能超過默認1000條
????????///?

????????public?int?MaxRecordPerPage
????????{
????????????get?{?return?_maxRecordPerPage;?}
????????????set?{?_maxRecordPerPage?=?value;?}
????????}
????????///?
????????///?總頁數
????????///?
????????
????????public?int?PageCount
????????{
????????????get
????????????{
????????????????if?(PageSize?!=?0)
????????????????{
????????????????????if?(RecordCount?%?PageSize?==?0)
????????????????????{
????????????????????????_pageCount?=?RecordCount?/?PageSize;

????????????????????}
????????????????????else
????????????????????{
????????????????????????_pageCount?=?RecordCount?/?PageSize?+?1;
?????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-26?17:49??PagerControl\
?????文件???????17542??2018-07-19?09:07??PagerControl\App.ico
?????文件???????16218??2018-10-27?17:26??PagerControl\DataGridViewPagerControl.Designer.cs
?????文件???????20391??2018-10-27?17:26??PagerControl\DataGridViewPagerControl.cs
?????文件????????3552??2018-11-24?09:21??PagerControl\DataGridViewPagerControl.csproj
?????文件?????????352??2018-07-19?09:03??PagerControl\DataGridViewPagerControl.csproj.user
?????文件???????33751??2018-10-27?17:26??PagerControl\DataGridViewPagerControl.resx
?????目錄???????????0??2018-11-26?17:49??PagerControl\Properties\
?????文件????????1402??2018-10-02?16:39??PagerControl\Properties\AssemblyInfo.cs
?????文件????????2889??2018-10-01?20:22??PagerControl\Properties\Resources.Designer.cs
?????文件????????5817??2018-07-12?16:42??PagerControl\Properties\Resources.resx
?????目錄???????????0??2018-11-26?17:49??PagerControl\bin\
?????目錄???????????0??2018-11-26?17:49??PagerControl\bin\Debug\
?????文件???????44544??2018-11-24?09:24??PagerControl\bin\Debug\DataGridViewPagerControl.dll
?????文件???????32256??2018-11-24?09:24??PagerControl\bin\Debug\DataGridViewPagerControl.pdb
?????文件??????101888??2018-07-20?10:14??PagerControl\bin\Debug\HRPM.Common.dll
?????文件???????75264??2018-07-20?10:14??PagerControl\bin\Debug\HRPM.Common.pdb
?????目錄???????????0??2018-11-26?17:49??PagerControl\bin\Release\
?????文件???????41984??2018-07-19?08:53??PagerControl\bin\Release\DataGridViewPagerControl.dll
?????文件???????30208??2018-07-19?08:53??PagerControl\bin\Release\DataGridViewPagerControl.pdb
?????目錄???????????0??2018-11-26?17:49??PagerControl\obj\
?????目錄???????????0??2018-11-26?17:49??PagerControl\obj\Debug\
?????文件???????18783??2018-11-24?09:24??PagerControl\obj\Debug\DataGridViewPagerControl.PagerControl.resources
?????文件?????????180??2018-11-24?09:24??PagerControl\obj\Debug\DataGridViewPagerControl.Properties.Resources.resources
?????文件???????????0??2018-07-13?14:29??PagerControl\obj\Debug\DataGridViewPagerControl.csproj.CopyComplete
?????文件??????????42??2018-10-26?11:16??PagerControl\obj\Debug\DataGridViewPagerControl.csproj.CoreCompileInputs.cache
?????文件????????3660??2018-10-26?17:27??PagerControl\obj\Debug\DataGridViewPagerControl.csproj.FileListAbsolute.txt
?????文件????????1031??2018-10-28?14:36??PagerControl\obj\Debug\DataGridViewPagerControl.csproj.GenerateResource.Cache
?????文件????????4191??2018-10-26?17:26??PagerControl\obj\Debug\DataGridViewPagerControl.csprojResolveAssemblyReference.cache
?????文件???????44544??2018-11-24?09:24??PagerControl\obj\Debug\DataGridViewPagerControl.dll
?????文件???????32256??2018-11-24?09:24??PagerControl\obj\Debug\DataGridViewPagerControl.pdb
............此處省略26個文件信息

評論

共有 條評論