WPF DataGrid分頁功能實現程式碼
在Silverlight中DataGrid分頁可以結合DataPager控制元件很容易實現，但是在WPF中沒有類似的，需要手動實現這樣一個控制元件：
1、建立一個UserControl，DP.xaml，程式碼如下，可以直接拷貝使用：
<UserControl x:Class="WFPSys.UserControls.DP"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<UserControl.Resources>
<!--每頁{0}/共{0}條-->
<Style x:Key="PageTextBlock1" TargetType="{x:Type TextBlock}">
<Setter Property="VerticalAlignment" Value="Center" />
<Setter Property="HorizontalAlignment" Value="Left" />
<Setter Property="FontSize" Value="13" />
<Setter Property="FontWeight" Value="Bold" />
<Setter Property="Foreground" Value="#FF333333" />
</Style>
<!--首頁上一頁等-->
<Style x:Key="PageTextBlock2" TargetType="{x:Type TextBlock}">
<Setter Property="VerticalAlignment" Value="Center" />
<Setter Property="HorizontalAlignment" Value="Left" />
<Setter Property="Margin" Value="0,10,0,0" />
<Setter Property="Width" Value="40" />
<Setter Property="Height" Value="23" />
<Setter Property="FontSize" Value="13" />
<Setter Property="Cursor" Value="Hand" />
<Setter Property="Foreground" Value="#FF333333" />
<Style.Triggers>
<Trigger Property="IsMouseOver" Value="True">
<Setter Property="Foreground" Value="#FF000000" />
<Setter Property="FontWeight" Value="Bold" />
</Trigger>
</Style.Triggers>
</Style>
<!--中間頁數-->
<Style x:Key="PageTextBlock3" TargetType="{x:Type TextBlock}">
<Setter Property="VerticalAlignment" Value="Center" />
<Setter Property="HorizontalAlignment" Value="Left" />
<Setter Property="Margin" Value="0,10,0,0" />
<Setter Property="Height" Value="23" />
<Setter Property="Width" Value="30" />
<Setter Property="FontSize" Value="10" />
<Setter Property="Cursor" Value="Hand" />
<Setter Property="Foreground" Value="#FF333333" />
<Style.Triggers>
<Trigger Property="IsMouseOver" Value="True">
<Setter Property="Foreground" Value="#FF000000" />
<Setter Property="FontWeight" Value="Bold" />
</Trigger>
<Trigger Property="IsEnabled" Value="False">
<Setter Property="Foreground" Value="#FF000000" />
<Setter Property="FontWeight" Value="Bold" />
</Trigger>
</Style.Triggers>
</Style>
<Style x:Key="PageTextBox" TargetType="{x:Type TextBox}">
<Setter Property="Height" Value="25" />
<Setter Property="Width" Value="40" />
<Setter Property="BorderBrush" Value="{x:Null}" />
<Setter Property="HorizontalAlignment" Value="Left" />
<Setter Property="VerticalAlignment" Value="Bottom" />
<Setter Property="Background">
<Setter.Value>
<ImageBrush ImageSource="/WFPSys;component/Images/Page_TextBack.png" ></ImageBrush>
</Setter.Value>
</Setter>
<Style.Triggers>
<Trigger Property="IsReadOnly" Value="True">
<Setter Property="Background" Value="#FFCCCCCC" />
</Trigger>
</Style.Triggers>
</Style>
<Style x:Key="PageButton" TargetType="{x:Type Button}">
<Setter Property="Height" Value="25" />
<Setter Property="Width" Value="30" />
<Setter Property="HorizontalAlignment" Value="Left" />
<Setter Property="VerticalAlignment" Value="Bottom" />
</Style>
</UserControl.Resources>
<Grid>
<Border CornerRadius="3" Background="Transparent" BorderBrush="{x:Null}">
<Grid HorizontalAlignment="Stretch" Margin="5 0 5 0" VerticalAlignment="Top" Width="Auto" Height="30">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="150"/>
<ColumnDefinition Width="500" MinWidth="500"/>
</Grid.ColumnDefinitions>
<TextBlock Name="tbkRecords" Grid.Column="0" Style="{StaticResource PageTextBlock1}" />
<StackPanel Orientation="Horizontal" HorizontalAlignment="Right" Grid.Column="1">
<Grid>
<Grid.RowDefinitions >
<RowDefinition Height="30"></RowDefinition>
</Grid.RowDefinitions>
<Grid.ColumnDefinitions>
<ColumnDefinition Width="50"/>
<ColumnDefinition Width="50"/>
<ColumnDefinition Width="*"/>
<ColumnDefinition Width="50"/>
<ColumnDefinition Width="50"/>
<ColumnDefinition Width="50"/>
<ColumnDefinition Width="30"/>
</Grid.ColumnDefinitions>
<TextBlock Grid.Column="0" Name="btnFirst" Text="首頁" IsEnabled="False" Style="{StaticResource PageTextBlock2}" />
<TextBlock Grid.Column="1" Name="btnPrev" Text="上一頁" IsEnabled="False" Style="{StaticResource PageTextBlock2}" />
<Grid Grid.Column="2" Name="grid" >
<Grid.RowDefinitions>
<RowDefinition Height="30" ></RowDefinition>
</Grid.RowDefinitions>
</Grid>
<TextBlock Grid.Column="3" x:Name="btnNext" Text="下一頁" IsEnabled="False" Style="{StaticResource PageTextBlock2}" />
<TextBlock Grid.Column="4" x:Name="btnLast" Text="未頁" IsEnabled="False" Style="{StaticResource PageTextBlock2}"/>
<TextBox Grid.Column="5" x:Name="pageGo" MaxLength="6" IsReadOnly="True" Style="{StaticResource PageTextBox}" />
<Button Grid.Column="6" x:Name="btnGo" Content="GO" IsEnabled="False" Style="{StaticResource PageButton}" />
</Grid>
</StackPanel>
</Grid>
</Border>
</Grid>
</UserControl>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
using System.Text.RegularExpressions;
namespace WFPSys.UserControls
{
/// <summary>
/// DP.xaml 的互動邏輯
/// </summary>
public partial class DP : UserControl
{
public DP()
{
InitializeComponent();
this.Loaded += delegate
{
//首頁
this.btnFirst.MouseLeftButtonUp += new MouseButtonEventHandler(btnFirst_Click);
this.btnFirst.MouseLeftButtonDown += new MouseButtonEventHandler(btnFirst_MouseLeftButtonDown);
//上一頁
this.btnPrev.MouseLeftButtonUp += new MouseButtonEventHandler(btnPrev_Click);
this.btnPrev.MouseLeftButtonDown += new MouseButtonEventHandler(btnPrev_MouseLeftButtonDown);
//下一頁
this.btnNext.MouseLeftButtonUp += new MouseButtonEventHandler(btnNext_Click);
this.btnNext.MouseLeftButtonDown += new MouseButtonEventHandler(btnNext_MouseLeftButtonDown);
//末頁
this.btnLast.MouseLeftButtonUp += new MouseButtonEventHandler(btnLast_Click);
this.btnLast.MouseLeftButtonDown += new MouseButtonEventHandler(btnLast_MouseLeftButtonDown);
this.btnGo.Click += new RoutedEventHandler(btnGo_Click);
};
}
private DataTable _dt = new DataTable();
//每頁顯示多少條
private int pageNum = 10;
//當前是第幾頁
private int pIndex = 1;
//物件
private DataGrid grdList;
//最大頁數
private int MaxIndex = 1;
//一共多少條
private int allNum = 0;
#region 初始化資料
/// <summary>
/// 初始化資料
/// </summary>
/// <param name="grd"></param>
/// <param name="dtt"></param>
/// <param name="Num"></param>
public void ShowPages(DataGrid grd, DataTable ds, int Num)
{
if (ds == null || ds.Rows.Count == 0)
return;
if (ds.Rows.Count == 0)
return;
DataTable dt = ds;
this._dt = dt.Clone();
this.grdList = grd;
this.pageNum = Num;
this.pIndex = 1;
foreach (DataRow r in dt.Rows)
this._dt.ImportRow(r);
SetMaxIndex();
ReadDataTable();
if (this.MaxIndex > 1)
{
this.pageGo.IsReadOnly = false;
this.btnGo.IsEnabled = true;
}
}
#endregion
#region 畫資料
/// <summary>
/// 畫資料
/// </summary>
private void ReadDataTable()
{
try
{
DataTable tmpTable = new DataTable();
tmpTable = this._dt.Clone();
int first = this.pageNum * (this.pIndex - 1);
first = (first > 0) ? first : 0;
//如果總數量大於每頁顯示數量
if (this._dt.Rows.Count >= this.pageNum * this.pIndex)
{
for (int i = first; i < pageNum * this.pIndex; i++)
tmpTable.ImportRow(this._dt.Rows[i]);
}
else
{
for (int i = first; i < this._dt.Rows.Count; i++)
tmpTable.ImportRow(this._dt.Rows[i]);
}
this.grdList.ItemsSource = tmpTable.DefaultView;
tmpTable.Dispose();
}
catch
{
MessageBox.Show("錯誤");
}
finally
{
DisplayPagingInfo();
}
}
#endregion
#region 畫每頁顯示等資料
/// <summary>
/// 畫每頁顯示等資料
/// </summary>
private void DisplayPagingInfo()
{
if (this.pIndex == 1)
{
this.btnPrev.IsEnabled = false;
this.btnFirst.IsEnabled = false;
}
else
{
this.btnPrev.IsEnabled = true;
this.btnFirst.IsEnabled = true;
}
if (this.pIndex == this.MaxIndex)
{
this.btnNext.IsEnabled = false;
this.btnLast.IsEnabled = false;
}
else
{
this.btnNext.IsEnabled = true;
this.btnLast.IsEnabled = true;
}
this.tbkRecords.Text = string.Format("每頁{0}條/共{1}條", this.pageNum, this.allNum);
int first = (this.pIndex - 4) > 0 ? (this.pIndex - 4) : 1;
int last = (first + 9) > this.MaxIndex ? this.MaxIndex : (first + 9);
this.grid.Children.Clear();
for (int i = first; i <= last; i++)
{
ColumnDefinition cdf = new ColumnDefinition();
this.grid.ColumnDefinitions.Add(cdf);
TextBlock tbl = new TextBlock();
tbl.Text = i.ToString();
tbl.Style = FindResource("PageTextBlock3") as Style;
tbl.MouseLeftButtonUp += new MouseButtonEventHandler(tbl_MouseLeftButtonUp);
tbl.MouseLeftButtonDown += new MouseButtonEventHandler(tbl_MouseLeftButtonDown);
if (i == this.pIndex)
tbl.IsEnabled = false;
Grid.SetColumn(tbl, this.grid.ColumnDefinitions.Count - 1);
Grid.SetRow(tbl, 0);
this.grid.Children.Add(tbl);
}
}
#endregion
#region 首頁
/// <summary>
/// 首頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFirst_Click(object sender, System.EventArgs e)
{
this.pIndex = 1;
ReadDataTable();
}
/// <summary>
/// 首頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFirst_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
e.Handled = true;
}
#endregion
#region 上一頁
/// <summary>
/// 上一頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrev_Click(object sender, System.EventArgs e)
{
if (this.pIndex <= 1)
return;
this.pIndex--;
ReadDataTable();
}
/// <summary>
/// 上一頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrev_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
e.Handled = true;
}
#endregion
#region 下一頁
/// <summary>
/// 下一頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnNext_Click(object sender, System.EventArgs e)
{
if (this.pIndex >= this.MaxIndex)
return;
this.pIndex++;
ReadDataTable();
}
/// <summary>
/// 下一頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnNext_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
e.Handled = true;
}
#endregion
#region 未頁
/// <summary>
/// 未頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLast_Click(object sender, System.EventArgs e)
{
this.pIndex = this.MaxIndex;
ReadDataTable();
}
/// <summary>
/// 未頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLast_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
e.Handled = true;
}
#endregion
#region 設定最多大頁面
/// <summary>
/// 設定最多大頁面
/// </summary>
private void SetMaxIndex()
{
//多少頁
int Pages = this._dt.Rows.Count / pageNum;
if (this._dt.Rows.Count != (Pages * pageNum))
{
if (_dt.Rows.Count < (Pages * pageNum))
Pages--;
else
Pages++;
}
this.MaxIndex = Pages;
this.allNum = this._dt.Rows.Count;
}
#endregion
#region 跳轉到多少頁
/// <summary>
/// 跳轉到多少頁
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnGo_Click(object sender, RoutedEventArgs e)
{
if (IsNumber(this.pageGo.Text))
{
int pageNum = int.Parse(this.pageGo.Text);
if (pageNum > 0 && pageNum <= this.MaxIndex)
{
this.pIndex = pageNum;
ReadDataTable();
}
else if (pageNum > this.MaxIndex)
{
this.pIndex = this.MaxIndex;
ReadDataTable();
}
}
this.pageGo.Text = "";
}
#endregion
#region 分頁數字的點選觸發事件
private void tbl_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
TextBlock tbl = sender as TextBlock;
if (tbl == null)
return;
int index = int.Parse(tbl.Text.ToString());
this.pIndex = index;
if (index > this.MaxIndex)
this.pIndex = this.MaxIndex;
if (index < 1)
this.pIndex = 1;
ReadDataTable();
}
void tbl_MouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
e.Handled = true;
}
#endregion
private static Regex RegNumber = new Regex("^[0-9]+$");
#region 判斷是否是數字
/// <summary>
/// 判斷是否是數字
/// </summary>
/// <param name="valString"></param>
/// <returns></returns>
public static bool IsNumber(string valString)
{
Match m = RegNumber.Match(valString);
return m.Success;
}
#endregion
}
}
在WPF窗體中新增該使用者控制元件，如下：
<UserControl x:Class="WFPSys.JCZL.BigClass"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:my="clr-namespace:WFPSys.UserControls"
mc:Ignorable="d" Loaded="UserControl_Loaded" d:DesignHeight="448" d:DesignWidth="734">
<Grid Name="gdMainPanel">
<Grid.Background>
<ImageBrush ImageSource="/WFPSys;component/Images/public/navigation.png" />
</Grid.Background>
<Canvas x:Name="cplButtonPanel" Margin="0" Width="734" Height="44" HorizontalAlignment="Left" VerticalAlignment="Top" FlowDirection="RightToLeft">
<Canvas.Background>
<ImageBrush ImageSource="/WFPSys;component/Images/public/navigation.png" />
</Canvas.Background>
<Button Content=" 新增" Height="29" Name="btnAdd" Width="60" Margin="80,7.5,0,0" Style="{StaticResource ButtonFunction}" Click="btnAdd_Click">
<Button.Background>
<ImageBrush ImageSource="/WFPSys;component/Images/function/add.png" />
</Button.Background>
</Button>
<Button Content=" 重新整理" Height="29" Name="btnReload" Width="60" Margin="10,7.5,0,0" Style="{StaticResource ButtonFunction}" Click="btnReload_Click">
<Button.Background>
<ImageBrush ImageSource="/WFPSys;component/Images/function/reload.png" />
</Button.Background>
</Button>
</Canvas>
<DockPanel Name="dplDataPanel" Margin="0,44,0,0" Width="734" Height="404" HorizontalAlignment="Left" VerticalAlignment="Top">
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="0.9*"></RowDefinition>
<RowDefinition Height="0.1*"></RowDefinition>
</Grid.RowDefinitions>
<DataGrid Name="dgDataSource" ItemsSource="{Binding }" IsReadOnly="True" Grid.Row="0">
<DataGrid.Columns>
<DataGridTextColumn Width="50" Header="編號" Binding="{Binding ID}" />
<DataGridTextColumn Width="250" Header="類別名稱" Binding="{Binding TypeName}" />
<DataGridTextColumn Width="*" Header="類別描述" Binding="{Binding Description}" />
</DataGrid.Columns>
<DataGrid.ContextMenu>
<ContextMenu>
<!--<Separator />-->
<MenuItem x:Name="mitmDelete" Header="刪除專案" Click="mitmDelete_Click">
<MenuItem.Icon>
<Image Source="/WFPSys;component/Icons/Error.ico" />
</MenuItem.Icon>
</MenuItem>
<!--<Separator />-->
</ContextMenu>
</DataGrid.ContextMenu>
</DataGrid>
<my:DP x:Name="page" Grid.Row="1" /> <!--分頁使用者控制元件宣告-->
</Grid>
</DockPanel>
</Grid>
</UserControl>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using System.Collections.ObjectModel;
using Syit.Models;
using System.Data;
using Syit.BLLs;
namespace WFPSys.JCZL
{
/// <summary>
/// BigClass.xaml 的互動邏輯
/// </summary>
public partial class BigClass : UserControl
{
public BigClass()
{
InitializeComponent();
}
#region 功能按鈕事件
/// <summary>
/// 新增資料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
}
/// <summary>
/// 重新整理資料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnReload_Click(object sender, RoutedEventArgs e)
{
}
/// <summary>
/// 刪除收支專案資料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void mitmDelete_Click(object sender, RoutedEventArgs e)
{
if (true)
{
MessageBoxResult boxResult = MessageBox.Show(string.Format("您確定要刪除資料【{0}】所包含的資訊嗎？", ""), "詢問：", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No);
if (boxResult == MessageBoxResult.Yes)
{
MessageBox.Show("資料刪除成功！", "提示：", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
}
}
#endregion
#region 頁面載入事件
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
tb_BigTypesBLL bll = new tb_BigTypesBLL();
ObservableCollection<tb_BigTypes> list = new ObservableCollection<tb_BigTypes>();
foreach (DataRowView drv in bll.GetData().DefaultView)
{
tb_BigTypes item = new tb_BigTypes();
item.ID = int.Parse(drv["ID"].ToString());
item.TypeName = drv["TypeName"].ToString();
item.Description = drv["Description"].ToString();
item.IsDelete = int.Parse(drv["IsDelete"].ToString());
list.Add(item);
}
this.dgDataSource.DataContext = list; // 為DataGrid繫結資料來源
this.page.ShowPages(this.dgDataSource, bll.GetData(), 5); //這裡是呼叫設定分頁的函式
}
#endregion
}
}
效果截圖：
相關文章
- 分頁功能的實現
- 在WPF程式中實現PropertyGrid功能
- web 實現分頁列印功能Web
- 使用 jQuery 實現分頁功能jQuery
- WPF DataGrid實現單擊單元格直接編輯
- WPF datagrid mvvm multi select via customize datagridMVVM
- wpf datagrid樣式
- WPF DataGrid ItemsSource StaticResource
- DjangoRestFramework 實現分頁功能與搜尋功能DjangoRESTFramework
- php原聲實現分頁程式碼示例PHP
- 文章內容分頁功能實現
- WPF Datagrid display via DataGridTemplateColumn
- WPF datagrid scrollintoview in ViewModel of MVVMViewMVVM
- WPF datagrid show ImageBrush via DataGridTemplateColumn
- 100行程式碼實現一個vue分頁元件行程Vue元件
- WPF datagrid datagridtemplatecolumn DataGridTemplateColumn.CellEditingTemplate DataGridComboBoxColumn
- WPF SelectedItemCollection convert to IList and List, such as Datagrid SelectedItems
- WPF custom control contains datagrid,listbox,imageAI
- WPF datagrid scrolldown and change the marked the location in canvasCanvas
- Vue + Element UI + Lumen 實現通用表格功能 - 分頁VueUI
- WPF/C#：實現導航功能C#
- Vue + element.ui table 分頁功能+搜尋功能的實現VueUI
- Simple WPF: WPF 實現按鈕的長按，短按功能
- Asp.Net 5分鐘實現網頁實時監控程式碼ASP.NET網頁
- WPF手動實現切換頁面
- 關於黑馬旅遊網的實現 --- 分頁查詢功能，點選分頁碼不顯示資料
- elementUI實現分頁UI
- vue + axios 實現分頁引數傳遞，高階搜尋功能實現VueiOS
- Spring Boot入門系列（十六）使用pagehelper實現分頁功能Spring Boot
- WPF中Datagrid控制元件新增行號控制元件
- WPF --- 如何以Binding方式隱藏DataGrid列
- 實現【檢視更多】功能的程式碼
- 前端黑科技：使用 JavaScript 實現網頁掃碼功能前端JavaScript網頁
- WPF隨筆收錄-DataGrid固定右側列
- WPF DataGrid ContextMenu CommandParameter Relative x:Type ContextMenu ,Path=PlacementTargetContext
- WPF datagrid implement multi select via behavior selectionchanged event in MVVMMVVM
- Easyui datagrid 實現表格記錄拖拽UI
- 用低程式碼平臺，5分鐘實現報價轉訂單功能
- FTP客戶端c程式碼功能實現FTP客戶端C程式