WinForm自定分页

最新推荐文章于 2019-07-30 23:22:00 发布
最新推荐文章于 2019-07-30 23:22:00 发布
阅读量1.2k 收藏
点赞数
文章标签： winform datagrid null components dataset object
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/cxzhq2002/article/details/748953
版权

-------------------自定DataGrid

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Windows.Forms;

namespace Pagination.CommonTools
{
 public class PageGrid:DataGrid
 {
  private System.ComponentModel.Container components = null;

  public PageGrid()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if( components != null )
     components.Dispose();
   }
   base.Dispose( disposing );
  }

  #region 组件设计器生成的代码
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器
  /// 修改此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   components = new System.ComponentModel.Container();
  }
  #endregion

  protected override void OnPaint(PaintEventArgs pe)
  {
   // TODO: 在此添加自定义绘画代码

   // 调用基类 OnPaint
   base.OnPaint(pe);
  }
  private int pageCount=1;// 总页数
  private int pageRows=40;//每页行数
  private int rowCount=1;//总行数
  private int currentPageIndex=0;//当前页号
  private bool canPri=false; //能否前进
  private bool canNext=false; //能否后退
  private DataTable originalTable=new DataTable(); //原始表

  public void SetPageDataSource(DataTable dt) //对原始表进行处理,得到总行数rowCount,总页数pageCount
  {
   this.originalTable=dt;
   this.rowCount=dt.Rows.Count;
   this.pageCount=rowCount/pageRows;
   if(rowCount % pageRows>0)
   {
    this.pageCount=this.pageCount+1;
   }
   if(pageCount<1)
   {
    PageCount=1;
   }

   if(pageCount>currentPageIndex) //首次加载时对canNext, canPri处理
   {
    this.canNext=true;
   }
   else
   {
    this.canNext=false;
   }
   if(currentPageIndex>1)
   {
    this.canPri=true;
   }
   else
   {
    this.canPri=false;
   }

   BuildTable(this.currentPageIndex);
  }
  private void BuildTable(int index)//每页绑定到Temp表
  {
   if(index<1)
   {
    index=1;
   }
   if(index>this.pageCount)
   {
    index=this.pageCount;    
   }
   DataTable tempTable=this.originalTable.Copy();
   tempTable.Clear();
   int start=(index-1)*pageRows;
   int end=index*pageRows;
   if(end>this.rowCount)
   {
    end=this.rowCount;
   }
   for(int i=start;i<end;i++)
   {
    DataRow dr=tempTable.NewRow();
    dr.ItemArray=((DataRow)(this.originalTable.Rows[i])).ItemArray;
    tempTable.Rows.Add(dr);
   }
   this.DataSource=tempTable;
  }
  public void PriPage()
  {
   this.canNext=true;
   this.currentPageIndex=currentPageIndex-1;
   if(currentPageIndex<=1)
   {
    this.canPri=false;
   }
   else
   {
    this.canPri=true;
   }
   BuildTable(currentPageIndex);
  }

  public void NextPage()
  {
   this.canPri=true;
   this.currentPageIndex=currentPageIndex+1;
   if(currentPageIndex>=this.pageCount)
   {
    this.canNext=false;
   }
   else
   {
    this.canNext=true;
   }
   BuildTable(currentPageIndex);
  }
  
  public void FirstPage()
  {
   if(currentPageIndex ==1)
   {
    MessageBox.Show("已经到第一页！");
    return;
   }
   if(pageCount>1)
   {
    this.canPri=false;
    this.canNext=true;    
   }
   else
   {
    this.canPri=false;
    this.canNext=false;    
   }
   currentPageIndex =1;
   BuildTable(currentPageIndex);
  }
  public void LastPage()
  {
  if(currentPageIndex ==pageCount)
   {
    MessageBox.Show("已经到第一页！");
    return;
   }
  else if(PageCount>1)
  {
   this.canNext = false;
   this.canPri= true;   
  }
  else
  {
   this.canNext = false;
   this.canPri  = false;
  }
  this.currentPageIndex =pageCount;
  BuildTable(currentPageIndex);
}

  public void GoPage(int goindex)
  {
   if(goindex>pageCount)
   {
    MessageBox.Show("最大页数为"+ pageCount +",我们将会为您转到最后页", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
    currentPageIndex = pageCount;
    if(pageCount>1)
    {
     canPri= true;
     canNext = false;
    }
    else
    {
     canPri= false;
     canNext = false;
    }
   }
   else if(goindex==pageCount)
   {
    currentPageIndex = pageCount;
    if(pageCount>1)
    {
     canPri= true;
     canNext = false;
    }
    else
    {
     canPri= false;
     canNext = false;
    }    
   }
   else if(goindex<1)
   {
    MessageBox.Show("最小页数为1页,我们将会为您转到第一页", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
    currentPageIndex = 1;
    if(pageCount>1)
    {
     canPri= false;
     canNext = true;
    }
    else
    {
     canPri= false;
     canNext = false;
    }
   }
   else if(goindex==1)
   {
    if(pageCount>1)
    {
     canPri= false;
     canNext = true;
    }
    else
    {
     canPri= false;
     canNext = false;
    }
    currentPageIndex = 1;
   }
   else
   {
    currentPageIndex = goindex;
    if(pageCount>1)
    {
     canPri= true;
     canNext = true;
    }
    else
    {
     canPri= false;
     canNext = false;
    }
   }   
   BuildTable(currentPageIndex);
  }


  public bool CanPri
  {
   set
   {
    this.canPri=value;
   }
   get
   {
    return this.canPri;
   }
  }
  public bool CanNext
  {
   set
   {
    this.canNext=value;
   }
   get
   {
    return this.canNext;
   }
  }

  public int CurrentPageIndex
  {
   set
   {
    this.currentPageIndex=value;
   }
   get
   {
    return this.currentPageIndex;
   }
  }

  public int RowCount
  {
   set
   {
    this.rowCount=value;
   }
   get
   {
    return this.rowCount;
   }
  }

  public int PageCount
  {
   set
   {
    this.pageCount=value;
   }
   get
   {
    return this.pageCount;
   }
  }

  public int PageRows
  {
   set
   {
    this.pageRows=value;
   }
   get
   {
    return this.pageRows;
   }
  }
 }

}

------------------------------------------------

演示用例

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using Pagination.CommonTools;

namespace WinFormPageination
{
 /// <summary>
 /// Form1 的摘要说明。
 /// </summary>
 public class Form1 : System.Windows.Forms.Form
 {
  private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
  private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
  private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
  private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
  private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
  private System.Data.SqlClient.SqlConnection sqlConnection1;
  private System.Data.DataSet dataSet1;
  private PageGrid dataGrid1;
  private System.Data.DataColumn dataColumn1;
  private System.Windows.Forms.StatusBarPanel GridRows;
  private System.Windows.Forms.StatusBar statusBarPanel;
  private System.Windows.Forms.Button lastPage;
  private System.Windows.Forms.Button firstPage;
  private System.Windows.Forms.Button btnGoPage;
  private System.Windows.Forms.TextBox txtGoPage;
  private System.Windows.Forms.Label label2;
  private System.Windows.Forms.Label label3;
  private System.Windows.Forms.ComboBox cmbPage;
  private System.Windows.Forms.StatusBarPanel GridInfo;
  private System.Windows.Forms.Button nextPage;
  private System.Windows.Forms.Button previousPage;
  /// <summary>
  /// 必需的设计器变量。
  /// </summary>
  private System.ComponentModel.Container components = null;

  public Form1()
  {
   //
   // Windows 窗体设计器支持所必需的
   //  
   
   InitializeComponent();
   sqlDataAdapter1.Fill(dataSet1,"customer");
   dataGrid1.SetPageDataSource(dataSet1.Tables["customer"]);   
   loadCombBoxItem();

   previousPage.Enabled=dataGrid1.CanPri;
   nextPage.Enabled=dataGrid1.CanNext;
   GridInfo.Text="第"+dataGrid1.CurrentPageIndex.ToString()+"页/共"+dataGrid1.PageCount.ToString()+"页";
   GridRows.Text="每页"+dataGrid1.PageRows.ToString() +"笔记录"+"/共"+dataGrid1.RowCount.ToString()+"笔记录";

   //
   // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
   //
  }

  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if (components != null)
    {
     components.Dispose();
    }
   }
   base.Dispose( disposing );
  }

  #region Windows 窗体设计器生成的代码
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
   this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
   this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
   this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
   this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
   this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
   this.dataSet1 = new System.Data.DataSet();
   this.dataGrid1 = new Pagination.CommonTools.PageGrid();
   this.dataColumn1 = new System.Data.DataColumn();
   this.previousPage = new System.Windows.Forms.Button();
   this.nextPage = new System.Windows.Forms.Button();
   this.statusBarPanel = new System.Windows.Forms.StatusBar();
   this.GridInfo = new System.Windows.Forms.StatusBarPanel();
   this.GridRows = new System.Windows.Forms.StatusBarPanel();
   this.lastPage = new System.Windows.Forms.Button();
   this.firstPage = new System.Windows.Forms.Button();
   this.btnGoPage = new System.Windows.Forms.Button();
   this.txtGoPage = new System.Windows.Forms.TextBox();
   this.label2 = new System.Windows.Forms.Label();
   this.label3 = new System.Windows.Forms.Label();
   this.cmbPage = new System.Windows.Forms.ComboBox();
   ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
   ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
   ((System.ComponentModel.ISupportInitialize)(this.GridInfo)).BeginInit();
   ((System.ComponentModel.ISupportInitialize)(this.GridRows)).BeginInit();
   this.SuspendLayout();
   //
   // sqlDataAdapter1
   //
   this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
   this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
   this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
   this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
                           new System.Data.Common.DataTableMapping("Table", "Customers", new System.Data.Common.DataColumnMapping[] {
                                                       new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"),
                                                       new System.Data.Common.DataColumnMapping("CompanyName", "CompanyName"),
                                                       new System.Data.Common.DataColumnMapping("ContactName", "ContactName"),
                                                       new System.Data.Common.DataColumnMapping("ContactTitle", "ContactTitle"),
                                                       new System.Data.Common.DataColumnMapping("Address", "Address"),
                                                       new System.Data.Common.DataColumnMapping("City", "City"),
                                                       new System.Data.Common.DataColumnMapping("Region", "Region"),
                                                       new System.Data.Common.DataColumnMapping("PostalCode", "PostalCode"),
                                                       new System.Data.Common.DataColumnMapping("Country", "Country"),
                                                       new System.Data.Common.DataColumnMapping("Phone", "Phone"),
                                                       new System.Data.Common.DataColumnMapping("Fax", "Fax")})});
   this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
   //
   // sqlDeleteCommand1
   //
   this.sqlDeleteCommand1.CommandText = @"DELETE FROM Customers WHERE (CustomerID = @Original_CustomerID) AND (Address = @Original_Address OR @Original_Address IS NULL AND Address IS NULL) AND (City = @Original_City OR @Original_City IS NULL AND City IS NULL) AND (CompanyName = @Original_CompanyName) AND (ContactName = @Original_ContactName OR @Original_ContactName IS NULL AND ContactName IS NULL) AND (ContactTitle = @Original_ContactTitle OR @Original_ContactTitle IS NULL AND ContactTitle IS NULL) AND (Country = @Original_Country OR @Original_Country IS NULL AND Country IS NULL) AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND (Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL) AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL AND PostalCode IS NULL) AND (Region = @Original_Region OR @Original_Region IS NULL AND Region IS NULL)";
   this.sqlDeleteCommand1.Connection = this.sqlConnection1;
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerID", System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerID", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Address", System.Data.SqlDbType.NVarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_City", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CompanyName", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompanyName", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ContactName", System.Data.SqlDbType.NVarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ContactName", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ContactTitle", System.Data.SqlDbType.NVarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ContactTitle", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Country", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Country", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Fax", System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Fax", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PostalCode", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PostalCode", System.Data.DataRowVersion.Original, null));
   this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Region", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Region", System.Data.DataRowVersion.Original, null));
   //
   // sqlConnection1
   //
   this.sqlConnection1.ConnectionString = "workstation id=KEVIN;packet size=4096;user id=sa;initial catalog=Northwind;persis" +
    "t security info=True";
   //
   // sqlInsertCommand1
   //
   this.sqlInsertCommand1.CommandText = @"INSERT INTO Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) VALUES (@CustomerID, @CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region, @PostalCode, @Country, @Phone, @Fax); SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID = @CustomerID)";
   this.sqlInsertCommand1.Connection = this.sqlConnection1;
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerID", System.Data.SqlDbType.NVarChar, 5, "CustomerID"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CompanyName", System.Data.SqlDbType.NVarChar, 40, "CompanyName"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ContactName", System.Data.SqlDbType.NVarChar, 30, "ContactName"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ContactTitle", System.Data.SqlDbType.NVarChar, 30, "ContactTitle"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Address", System.Data.SqlDbType.NVarChar, 60, "Address"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 15, "City"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 15, "Region"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PostalCode", System.Data.SqlDbType.NVarChar, 10, "PostalCode"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Country", System.Data.SqlDbType.NVarChar, 15, "Country"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Phone", System.Data.SqlDbType.NVarChar, 24, "Phone"));
   this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fax", System.Data.SqlDbType.NVarChar, 24, "Fax"));
   //
   // sqlSelectCommand1
   //
   this.sqlSelectCommand1.CommandText = "SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region," +
    " PostalCode, Country, Phone, Fax FROM Customers";
   this.sqlSelectCommand1.Connection = this.sqlConnection1;
   //
   // sqlUpdateCommand1
   //
   this.sqlUpdateCommand1.CommandText = @"UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName, ContactName = @ContactName, ContactTitle = @ContactTitle, Address = @Address, City = @City, Region = @Region, PostalCode = @PostalCode, Country = @Country, Phone = @Phone, Fax = @Fax WHERE (CustomerID = @Original_CustomerID) AND (Address = @Original_Address OR @Original_Address IS NULL AND Address IS NULL) AND (City = @Original_City OR @Original_City IS NULL AND City IS NULL) AND (CompanyName = @Original_CompanyName) AND (ContactName = @Original_ContactName OR @Original_ContactName IS NULL AND ContactName IS NULL) AND (ContactTitle = @Original_ContactTitle OR @Original_ContactTitle IS NULL AND ContactTitle IS NULL) AND (Country = @Original_Country OR @Original_Country IS NULL AND Country IS NULL) AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND (Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL) AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL AND PostalCode IS NULL) AND (Region = @Original_Region OR @Original_Region IS NULL AND Region IS NULL); SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID = @CustomerID)";
   this.sqlUpdateCommand1.Connection = this.sqlConnection1;
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CustomerID", System.Data.SqlDbType.NVarChar, 5, "CustomerID"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CompanyName", System.Data.SqlDbType.NVarChar, 40, "CompanyName"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ContactName", System.Data.SqlDbType.NVarChar, 30, "ContactName"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ContactTitle", System.Data.SqlDbType.NVarChar, 30, "ContactTitle"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Address", System.Data.SqlDbType.NVarChar, 60, "Address"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@City", System.Data.SqlDbType.NVarChar, 15, "City"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 15, "Region"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PostalCode", System.Data.SqlDbType.NVarChar, 10, "PostalCode"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Country", System.Data.SqlDbType.NVarChar, 15, "Country"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Phone", System.Data.SqlDbType.NVarChar, 24, "Phone"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fax", System.Data.SqlDbType.NVarChar, 24, "Fax"));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CustomerID", System.Data.SqlDbType.NVarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CustomerID", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Address", System.Data.SqlDbType.NVarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_City", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "City", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CompanyName", System.Data.SqlDbType.NVarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "CompanyName", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ContactName", System.Data.SqlDbType.NVarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ContactName", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ContactTitle", System.Data.SqlDbType.NVarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ContactTitle", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Country", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Country", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Fax", System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Fax", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Phone", System.Data.SqlDbType.NVarChar, 24, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PostalCode", System.Data.SqlDbType.NVarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "PostalCode", System.Data.DataRowVersion.Original, null));
   this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Region", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Region", System.Data.DataRowVersion.Original, null));
   //
   // dataSet1
   //
   this.dataSet1.DataSetName = "NewDataSet";
   this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
   //
   // dataGrid1
   //
   this.dataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
    | System.Windows.Forms.AnchorStyles.Right)));
   this.dataGrid1.CanNext = true;
   this.dataGrid1.CanPri = true;
   this.dataGrid1.CurrentPageIndex = 1;
   this.dataGrid1.DataMember = "";
   this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dataGrid1.Location = new System.Drawing.Point(24, 24);
   this.dataGrid1.Name = "dataGrid1";
   this.dataGrid1.PageCount = 1;
   this.dataGrid1.PageRows = 10;
   this.dataGrid1.RowCount = 1;
   this.dataGrid1.Size = new System.Drawing.Size(720, 208);
   this.dataGrid1.TabIndex = 0;
   //
   // dataColumn1
   //
   this.dataColumn1.ColumnName = "Column1";
   //
   // previousPage
   //
   this.previousPage.Location = new System.Drawing.Point(128, 240);
   this.previousPage.Name = "previousPage";
   this.previousPage.TabIndex = 2;
   this.previousPage.Text = "上一页";
   this.previousPage.Click += new System.EventHandler(this.priPage_Click);
   //
   // nextPage
   //
   this.nextPage.Location = new System.Drawing.Point(224, 240);
   this.nextPage.Name = "nextPage";
   this.nextPage.TabIndex = 3;
   this.nextPage.Text = "下一页";
   this.nextPage.Click += new System.EventHandler(this.nextPage_Click);
   //
   // statusBarPanel
   //
   this.statusBarPanel.Location = new System.Drawing.Point(0, 280);
   this.statusBarPanel.Name = "statusBarPanel";
   this.statusBarPanel.Panels.AddRange(new System.Windows.Forms.StatusBarPanel[] {
                         this.GridInfo,
                         this.GridRows});
   this.statusBarPanel.ShowPanels = true;
   this.statusBarPanel.Size = new System.Drawing.Size(768, 22);
   this.statusBarPanel.TabIndex = 10;
   this.statusBarPanel.Text = "页数";
   //
   // GridInfo
   //
   this.GridInfo.Text = "页数";
   this.GridInfo.Width = 200;
   //
   // GridRows
   //
   this.GridRows.Text = "记录";
   this.GridRows.Width = 2000;
   //
   // lastPage
   //
   this.lastPage.Location = new System.Drawing.Point(320, 240);
   this.lastPage.Name = "lastPage";
   this.lastPage.TabIndex = 4;
   this.lastPage.Text = "最后一页";
   this.lastPage.Click += new System.EventHandler(this.lastPage_Click);
   //
   // firstPage
   //
   this.firstPage.Location = new System.Drawing.Point(32, 240);
   this.firstPage.Name = "firstPage";
   this.firstPage.TabIndex = 1;
   this.firstPage.Text = "第一页";
   this.firstPage.Click += new System.EventHandler(this.firstPage_Click);
   //
   // btnGoPage
   //
   this.btnGoPage.Location = new System.Drawing.Point(632, 239);
   this.btnGoPage.Name = "btnGoPage";
   this.btnGoPage.Size = new System.Drawing.Size(32, 23);
   this.btnGoPage.TabIndex = 7;
   this.btnGoPage.Text = "GO";
   this.btnGoPage.Click += new System.EventHandler(this.btnGoPage_Click);
   //
   // txtGoPage
   //
   this.txtGoPage.Location = new System.Drawing.Point(584, 240);
   this.txtGoPage.Name = "txtGoPage";
   this.txtGoPage.Size = new System.Drawing.Size(24, 21);
   this.txtGoPage.TabIndex = 6;
   this.txtGoPage.Text = "";
   this.txtGoPage.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.txtGoPage_KeyPress);
   //
   // label2
   //
   this.label2.Location = new System.Drawing.Point(552, 244);
   this.label2.Name = "label2";
   this.label2.Size = new System.Drawing.Size(32, 16);
   this.label2.TabIndex = 8;
   this.label2.Text = "转到";
   //
   // label3
   //
   this.label3.Location = new System.Drawing.Point(608, 244);
   this.label3.Name = "label3";
   this.label3.Size = new System.Drawing.Size(16, 12);
   this.label3.TabIndex = 9;
   this.label3.Text = "页";
   //
   // cmbPage
   //
   this.cmbPage.Location = new System.Drawing.Point(424, 240);
   this.cmbPage.Name = "cmbPage";
   this.cmbPage.Size = new System.Drawing.Size(121, 20);
   this.cmbPage.TabIndex = 5;
   this.cmbPage.Text = "请选择页数";
   this.cmbPage.SelectedIndexChanged += new System.EventHandler(this.cmbPage_SelectedIndexChanged);
   //
   // Form1
   //
   this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
   this.ClientSize = new System.Drawing.Size(768, 302);
   this.Controls.Add(this.cmbPage);
   this.Controls.Add(this.txtGoPage);
   this.Controls.Add(this.statusBarPanel);
   this.Controls.Add(this.nextPage);
   this.Controls.Add(this.previousPage);
   this.Controls.Add(this.dataGrid1);
   this.Controls.Add(this.lastPage);
   this.Controls.Add(this.firstPage);
   this.Controls.Add(this.btnGoPage);
   this.Controls.Add(this.label2);
   this.Controls.Add(this.label3);
   this.Name = "Form1";
   this.Text = "Form1";
   ((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
   ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
   ((System.ComponentModel.ISupportInitialize)(this.GridInfo)).EndInit();
   ((System.ComponentModel.ISupportInitialize)(this.GridRows)).EndInit();
   this.ResumeLayout(false);

  }
  #endregion

  /// <summary>
  /// 应用程序的主入口点。
  /// </summary>
  [STAThread]
  static void Main()
  {
   Application.Run(new Form1());   
  }

  private void loadCombBoxItem()
  {
   for(int i=1; i<=dataGrid1.PageCount; i++)
   {
    cmbPage.Items.Add(i);
   }
  }
  private void showPageStatus()
  {
   previousPage.Enabled=dataGrid1.CanPri;
   nextPage.Enabled=dataGrid1.CanNext;
   GridInfo.Text="第"+dataGrid1.CurrentPageIndex.ToString()+"页/共"+dataGrid1.PageCount.ToString()+"页";
   GridRows.Text="每页"+dataGrid1.PageRows.ToString() +"笔记录"+"/共"+dataGrid1.RowCount.ToString()+"笔记录";
   cmbPage.SelectedIndex = dataGrid1.CurrentPageIndex-1;
  }


  private void priPage_Click(object sender, System.EventArgs e)
  {
   dataGrid1.PriPage();
   showPageStatus();

  }

  private void nextPage_Click(object sender, System.EventArgs e)
  {
   dataGrid1.NextPage();
   showPageStatus();

  }

  private void firstPage_Click(object sender, System.EventArgs e)
  {
   dataGrid1.FirstPage();
   showPageStatus();
  }

  private void lastPage_Click(object sender, System.EventArgs e)
  {
   dataGrid1.LastPage();
   showPageStatus();

  }

  private void btnGoPage_Click(object sender, System.EventArgs e)
  {
   try
   {
    string tempTxtGoPage = txtGoPage.Text.ToString().Trim();
    if(tempTxtGoPage!="")
    {
     int index = Convert.ToInt16(tempTxtGoPage);

     dataGrid1.GoPage(index);
     txtGoPage.Text="";
     showPageStatus();
    }

   }
   catch (Exception ei)
   {
    MessageBox.Show(ei.Message,"Information",MessageBoxButtons.OK,MessageBoxIcon.Warning);
   }

  
  }

  private void cmbPage_SelectedIndexChanged(object sender, System.EventArgs e)
  {
   int index = cmbPage.SelectedIndex+1;
   dataGrid1.GoPage(index);
   showPageStatus();

  }
  
  private void txtGoPage_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e)
  {
   if(e.KeyChar == (char)13) // Convert.ToInt32()e.KeyCahr)
   {
    try
    {
     string tempTxtGoPage = txtGoPage.Text.ToString().Trim();
     if(tempTxtGoPage!="")
     {
      int index = Convert.ToInt16(tempTxtGoPage);

      dataGrid1.GoPage(index);
      txtGoPage.Text="";
      showPageStatus();
     }

    }
    catch (Exception ei)
    {
     MessageBox.Show(ei.Message,"Information",MessageBoxButtons.OK,MessageBoxIcon.Warning);
    }
   }
   if (e.KeyChar == (char) 27)
   {
    txtGoPage.Text="";
   }
  
  }

 }
}

cxzhq2002
关注
在C#里实现DATAGRID的打印预览和打印
qieyj的专栏
04-08 2593
很多人都在论坛里问，如何实现DATAGRID的打印预览和打印，现在我就把这方面的源代码告诉大家。这段代码也花费了我1个晚上的时间，呵呵！数据库是基于sql server2000自带的northwind。源代码如下：using System;using System.Drawing;using System.Collections;using System.ComponentModel;usin
VB.NET学习笔记：WinForm自定义DataGridView分页组合控件
zyjq52uys的博客
12-29 3311
测试环境：windows 7和Microsoft Visual Studio 2015 点击下载本文资源 VB.NET虽然提供了大量控件供我们使用，但很多控件仅提供最基础的功能。比如用DataGridView控件可以非常方便显示或操作数据库数据， 但却没有分页功能。本文介绍通过自定义窗体库组合VB.NET已有控件实现DataGridView控件分页显示功能。 测试效果如图： DataGri...
vb.net DataGridView 预览打印
05-31
vb.net DataGridView 打印预览及调用打印机方面的源码
C# WINFORM打印datagridview数据带打印预览
01-07 4779
<br />using System;<br />using System.Collections;<br />using System.ComponentModel;<br />using System.Drawing;<br />using System.Drawing.Printing;<br />using System.Data;<br />using System.Windows.Forms;<br />namespace ChengPinYouQiYe<br />{<br />    clas
.Net程序增删改查
weixin_33859504的博客
05-16 316
1、插入语句INSERT语句用来向表、分区或视图中添加行。可以向单个表或者多个表中添加数据行。单表插入将会向一个表中插入一行数据，这行数据可以显示地列出插入值也可以通过一个子查询来获取。多表插入将会向一个或多个表中插入行，并且会通过子查询获取值来计算所插入行的值。1.1、INSERT如果你要插入表中所定义的所有字段的值，那么字段的列表是可选的。但是如果你只想提供部分字段的值...
WinForm轻松实现自定义分页 （转载）
aiquan6271的博客
07-23 387
转载至http://xuzhihong1987.blog.163.com/blog/static/267315872011315114240140/ 以前都是做web开发，最近接触了下WinForm，发现WinForm分页控件好像都没有，网上搜索了一下，发现有很多网友写的分页控件，分页效果应该都能实现吧，只是其风格都不是很符合我想要的。做web的时候，我习惯了Extjs的Grid分页效...
C# Winform+devexpress 自定义分页控件
03-29
在.NET开发环境中，C# WinForm应用经常需要处理大量数据，这时自定义分页控件显得尤为重要。"C# Winform+devexpress 自定义分页控件"是为了解决这个问题而设计的一种解决方案，它利用DevExpress组件库的强大功能，...
C# Winform DataGridView 公共分页实现
03-25
本篇文章将深入探讨如何在C# WinForm应用中实现一个公共的分页功能，以优化大量数据的显示，提高用户体验。 `DataGridView`控件是WinForms中的数据网格视图，它允许开发者以表格的形式展示数据。在处理大量数据时，...
WinForm 分页控件
08-08
在Windows Forms（WinForm）开发中，为了处理大量数据并提高用户体验，通常会采用分页控件。分页控件允许用户逐页浏览数据，而不是一次性加载所有数据，这样可以节省内存并加快应用的响应速度。本文将详细介绍...
Winform分页用户控件
05-05
在Windows Forms（Winform）开发中，用户界面的构建经常涉及到数据展示，特别是大量数据时，分页功能显得尤为重要。本篇文章将详细讲解如何创建一个自定义的分页用户控件，以解决在Winform应用中高效处理大量数据的...
winform自定义分页
01-05
winform使用bindingNavigator与bindingSource定义分页控件，实现分页功能
.net增删改查
08-05
是一个项目，能直接在vs2010上运行，本人作品，适合初学者
,net增删改查
05-23
ASP.NET大作业，实现增删改查功能。(部分有问题，提出修改)
WinForm自定义分页控件
02-22
WinForm自定义分页控件完整实例，导入可用
WinForm轻松实现自定义分页
05-28
以前都是做web开发，最近接触了下WinForm，发现WinForm分页控件好像都没有，网上搜索了一下，发现有很多网友写的分页控件，分页效果应该都能实现吧，只是其风格都不是很符合我想要的。做web的时候，我习惯了Extjs的Grid分页效果，所以也想在WinForm中做个类似的效果，所以咬咬牙，做个山寨版本的吧，虽然自己写费时费力，在项目进度考虑中不是很可取，但是还是特别想山寨一回，做自己喜欢的风格--仿Extjs。
C# WinForm 技巧一： 自定义分页控件
weixin_33967071的博客
12-31 131
一、摘要        以前都是从事B/S开发，现在由于公司发展需要有个比较大的C/S项目，数据量比较大，就想实现一个和WEB一样的分页控件，在网上找了好久没有找到想要的。今天在博客园看到Nosnowwolf写的winform 分页控件，源码下载刚刚好是我现在要解决的问题，根据Nosnowwolf 的思路试用了一下，下面是我在使用这个控件的各个过程。 二、本文大纲        ...
winform自定义分页控件
weixin_30663391的博客
07-30 250
1、控件代码： public partial class PagerControl : UserControl { #region 构造函数 public PagerControl() { InitializeComponent(); } #endregion ...
C#（ASP.NET）增删改
FRP757721728的博客
05-09 353
1.增加 （1）DataList数据库数据绑定（https://www.cnblogs.com/furuipeng/p/10509859.html） （2）执行存储过程底层代码： （3）调用存储过程与传参： （4）刷新页面： 2.删除 （1）DataList数据库数据绑定（https://www.cnblogs.com/furuipeng/p/10509859....
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值