### C# 中使用 GridControl 实现分页和模糊查询 #### 1. 创建项目并配置 GridControl 为了实现在 C# WinForms 应用程序中使用 `GridControl` 进行分页和模糊查询，首先需要创建一个新的 Windows Forms App (.NET Framework) 项目，并安装 DevExpress 控件库。 ```csharp using System; using System.Linq; using System.Windows.Forms; using DevExpress.XtraGrid.Views.Grid; namespace GridControlPagingSearch { public partial class MainForm : Form { private BindingSource bindingSource = new BindingSource(); public MainForm() { InitializeComponent(); // 初始化数据源 var data = Enumerable.Range(0, 100).Select(i => new { ID = i, Name = $"Item{i}" }).ToList(); bindingSource.DataSource = data; gridControl1.DataSource = bindingSource; gridView1.OptionsView.ShowGroupPanel = false; // 隐藏组面板 SetupPagingControls(); // 设置分页控件 SetupSearchBox(); // 设置搜索框 } } } ``` #### 2. 添加分页功能 通过添加两个按钮来控制页面切换，并计算显示的数据范围。这里假设每页最多显示 10 条记录[^1]： ```csharp private int currentPageIndex = 0; private const int pageSize = 10; private void SetupPagingControls() { btnPrevious.Click += (s, e) => MoveToPage(currentPageIndex - 1); btnNext.Click += (s, e) => MoveToPage(currentPageIndex + 1); UpdatePaginationButtonsState(); } private void MoveToPage(int pageIndex) { if (pageIndex >= 0 && pageIndex * pageSize < ((List<object>)bindingSource.List).Count()) { currentPageIndex = pageIndex; ApplyFilteringAndSorting(); UpdatePaginationButtonsState(); } } private void UpdatePaginationButtonsState() { bool isFirstPage = currentPageIndex == 0; bool isLastPage = currentPageIndex * pageSize + pageSize >= ((List<object>)bindingSource.List).Count(); btnPrevious.Enabled = !isFirstPage; btnNext.Enabled = !isLastPage; } ``` #### 3. 实现模糊查询 在窗体上放置一个 TextBox 和 Button 组件作为输入条件区域。当点击按钮时触发过滤操作[^2]: ```csharp private string currentSearchText = ""; private void SetupSearchBox() { txtSearch.KeyDown += TxtSearch_KeyDown; btnSearch.Click += BtnSearch_Click; } private void TxtSearch_KeyDown(object sender, KeyEventArgs e) { if(e.KeyCode == Keys.Enter){ PerformSearch(txtSearch.Text.Trim()); } } private void BtnSearch_Click(object sender, EventArgs e) { PerformSearch(txtSearch.Text.Trim()); } private void PerformSearch(string searchText) { currentSearchText = searchText.ToLowerInvariant().Trim(); ApplyFilteringAndSorting(); } private void ApplyFilteringAndSorting() { var filteredData = ((List<dynamic>)bindingSource.DataSource) .Where(item => item.Name.ToString().ToLowerInvariant().Contains(currentSearchText)) .Skip(currentPageIndex * pageSize) .Take(pageSize) .ToList(); bindingSource.DataSource = filteredData; gridView1.RefreshData(); } ``` 以上代码展示了如何在一个简单的例子中集成分页与模糊查询的功能。实际应用可能更加复杂，具体取决于业务需求和技术栈的选择。