如何在WinForm中对DataGrid进行分页显示

最新推荐文章于 2023-11-02 13:02:51 发布

kable999

最新推荐文章于 2023-11-02 13:02:51 发布

阅读量377

点赞数

分类专栏： .NET 文章标签： datagrid winform dataset exception components sql server

本文链接：https://blog.csdn.net/kable999/article/details/4837952

版权

.NET 专栏收录该内容

97 篇文章 0 订阅

订阅专栏

在网上大多数对 DataGrid 进行分页的例子都是 Asp.net 环境下的，其实在 WinForm 中也很简单。以下就是简单举一个例子。

首先，需要定义一个数据库存储过程，用来获得指定页的数据记录，大致的数据结构和存储过程如下（在 SQL Server 2000 下）：

字段名	类型	备注
EmployeeID	Int	自增字段，主键
EmployeeName	Varchar(20)
Salary	Int
CellPhone	Varchar(20)
EmailAddress	Varchar(20)

存储过程为：

CREATE PROCEDURE GetEmployees @EmployeeNum int, @StartNO int, @@TotalCount INT OUTPUT, @@RealNum INT OUTPUT AS

-- Get employees from DB through the specific number and the start position

DECLARE @PreRecCount VARCHAR( 10 )

DECLARE @CurRecCount VARCHAR( 10 )

SELECT @@TotalCount = COUNT(*) FROM EmployeeInfo

IF @@TotalCount > ( @StartNO + 1 ) * @EmployeeNum

SET @@RealNum = @EmployeeNum

ELSE

SET @@RealNum = @@TotalCount - @StartNO * @EmployeeNum

-- Get employees by the computed number

SET @CurRecCount = CAST( @StartNO * @EmployeeNum + @@RealNum AS VARCHAR( 10 ) )

IF @STARTNO = 0

EXEC( 'SELECT TOP ' + @CurRecCount + ' * FROM EmployeeInfo ORDER BY EmployeeID ASC' )

ELSE

BEGIN

SET @PreRecCount = CAST( @StartNO * @EmployeeNum AS VARCHAR( 10 ) )

EXEC( 'SELECT TOP ' + @CurRecCount + ' * FROM EmployeeInfo WHERE EmployeeID NOT IN '

+ '(SELECT TOP ' + @PreRecCount + ' EmployeeID FROM EmployeeInfo ORDER BY EmployeeID ASC) '

+ 'ORDER BY EmployeeID ASC'

)

END

然后就是调用存储过程来进行显示，比较完整的源代码如下：

//------------------------ Multi Page Demo ------------------------------------

//-----------------------------------------------------------------------------

//---File:frmMultiPagesDemo.cs

//---Description:The main form file to show how to use pages in datagrid

//---Author:Knight

//---Date:Mar.23, 2006

//-----------------------------------------------------------------------------

//-----------------------{ Multi Page Demo }-----------------------------------

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

namespace CSDataGrid

{

/// <summary>

/// Summary description for frmMultiPages.

/// </summary>

public class frmMultiPages : System.Windows.Forms.Form

{

private System.Windows.Forms.Label lblPageInfo;

private System.Windows.Forms.Button btnPrevious;

private System.Windows.Forms.Button btnNext;

protected SqlConnection sqlConn = new SqlConnection();

protected SqlDataAdapter sqlDAdapter = null ;

protected DataSet sqlRecordSet = null ;

private int nCurPageNum = 0;

private const int REC_NUM_PER_PAGE = 3;

private int nTotalCount;

private int nRealNum;

private int nTotalPage;

private System.Windows.Forms.DataGrid dtgUserInfo;

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.Container components = null ;

public frmMultiPages()

{

// Required for Windows Form Designer support

InitializeComponent();

// TODO: Add any constructor code after InitializeComponent call

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if ( disposing )

{

if (components != null )

{

components.Dispose();

}

base .Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this .dtgUserInfo = new System.Windows.Forms.DataGrid();

this .lblPageInfo = new System.Windows.Forms.Label();

this .btnPrevious = new System.Windows.Forms.Button();

this .btnNext = new System.Windows.Forms.Button();

((System.ComponentModel.ISupportInitialize)(this .dtgUserInfo)).BeginInit();

this .SuspendLayout();

// dtgUserInfo

this .dtgUserInfo.DataMember = "";

this .dtgUserInfo.HeaderForeColor = System.Drawing.SystemColors.ControlText;

this .dtgUserInfo.Location = new System.Drawing.Point(16, 16);

this .dtgUserInfo.Name = "dtgUserInfo";

this .dtgUserInfo.Size = new System.Drawing.Size(552, 416);

this .dtgUserInfo.TabIndex = 0;

// lblPageInfo

this .lblPageInfo.AutoSize = true ;

this .lblPageInfo.Location = new System.Drawing.Point(16, 440);

this .lblPageInfo.Name = "lblPageInfo";

this .lblPageInfo.Size = new System.Drawing.Size(83, 16);

this .lblPageInfo.TabIndex = 1;

this .lblPageInfo.Text = "{0} of {1} Pages";

// btnPrevious

this .btnPrevious.Location = new System.Drawing.Point(408, 440);

this .btnPrevious.Name = "btnPrevious";

this .btnPrevious.TabIndex = 2;

this .btnPrevious.Text = "Previous";

this .btnPrevious.Click += new System.EventHandler(this .btnPrevious_Click);

// btnNext

this .btnNext.Location = new System.Drawing.Point(488, 440);

this .btnNext.Name = "btnNext";

this .btnNext.TabIndex = 3;

this .btnNext.Text = "Next";

this .btnNext.Click += new System.EventHandler(this .btnNext_Click);

// frmMultiPages

this .AutoScaleBaseSize = new System.Drawing.Size(5, 13);

this .ClientSize = new System.Drawing.Size(584, 469);

this .Controls.Add(this .btnNext);

this .Controls.Add(this .btnPrevious);

this .Controls.Add(this .lblPageInfo);

this .Controls.Add(this .dtgUserInfo);

this .FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;

this .MaximizeBox = false ;

this .Name = "frmMultiPages";

this .Text = "Multi Pages In DataGrid";

this .Load += new System.EventHandler(this .frmMultiPages_Load);

((System.ComponentModel.ISupportInitialize)(this .dtgUserInfo)).EndInit();

this .ResumeLayout(false );

}

#endregion

private void frmMultiPages_Load(object sender, System.EventArgs e)

{

//Set connection string

sqlConn.ConnectionString = yourconnectionstring ;

//Connect to DB

if ( ConnectDB() )

{

//Bind data to datagrid

BindData();

}

/// <summary>

/// Connect to DB

/// </summary>

/// <returns> If connected, return True; else return False </returns>

private bool ConnectDB()

{

//Check current connection's state

try

{

if ( sqlConn.State == ConnectionState.Closed

|| sqlConn.State == ConnectionState.Broken )

{

//Connection is not available

sqlConn.Close();

}

else

//Connection is available

return true ;

}

catch {};

//Re-connect

try

{

sqlConn.Open();

}

catch (SqlException e)

{

//Sql's exception

MessageBox.Show( e.Message );

}

catch (Exception e)

{

//Other exception

MessageBox.Show( e.Message );

}

if ( sqlConn.State == ConnectionState.Closed

|| sqlConn.State == ConnectionState.Broken )

//Connection is not available

return false ;

else

//Connection is available

return true ;

}

private void AddDGStyle()

{

DataGridTableStyle ts1 = new DataGridTableStyle();

//specify the table from dataset (required step)

ts1.MappingName = "EmployeeInfo";

PropertyDescriptorCollection pdc = this .BindingContext

[sqlRecordSet, "EmployeeInfo"].GetItemProperties();

DataGridColumnStyle TextCol = new DataGridTextBoxColumn( pdc["EmployeeID"], "i" );

TextCol.MappingName = "EmployeeID";

TextCol.HeaderText = "EmployeeID";

TextCol.Width = 0;

TextCol.ReadOnly = true ;