Datagridview自動翻頁

using    System; 
using    System.Collections.Generic; 
using    System.ComponentModel; 
using    System.Data; 
using    System.Data.SqlClient; 
using    System.Drawing; 
using    System.Text; 
using    System.Windows.Forms; 

namespace    WindowsApplication1 

        
public   partial   class   Form1   :   Form 
        

                
private   DataSet   myDataSet   =   new   DataSet(); 
                
private   int   DataRowsCountTotal   =   0
                
private   int   PageCount   =   0
                
private   int   residualRowsCount   =   0
                
private   int   TakeCount   =   0
                
public   Form1() 
                

                        InitializeComponent(); 
                }
 

                
private   void   Form1_Load(object   sender,   EventArgs   e) 
                

                        
string   myConnectString   =   "Data   Source=emp05;Initial   Catalog=SHOWS_Web;Persist   Security   Info=True;User   ID=sa;Password=inetsn@SQL#No.0"
                        SqlConnection   myConn   
=   new   SqlConnection(myConnectString); 
                        myConn.Open(); 
                        SqlCommand   myComm   
=   new   SqlCommand("SELECT   UserID,UserName   FROM   Users",   myConn); 
                        SqlDataAdapter   myAdap   
=   new   SqlDataAdapter(); 
                        myAdap.SelectCommand   
=   myComm; 
                        myAdap.Fill(myDataSet,
"myData"); 
                        DataRowsCountTotal   
=   PageCount   =   myDataSet.Tables[0].Rows.Count; 
                        PageCount   
=   DataRowsCountTotal   /   5
                        residualRowsCount   
=   DataRowsCountTotal   %   5
                        DataGrieDataBind(
0); 
                        
this.timer1.Start(); 
                }
 

                
private   void   DataGrieDataBind(int   PageSequence) 
                

                        DataTable   myDt   
=   new   DataTable(); 
                        myDt   
=   myDataSet.Tables[0].Clone(); 
                        myDt.Clear(); 
                        
if(PageSequence   >     PageCount) 
                        

                                
for(int   i   =5*PageSequence   -1;   i   <=     DataRowsCountTotal   -1;i++
                                

                                        myDt.ImportRow(myDataSet.Tables[
0].Rows[i]); 
                                }
 
                        }
 
                        
else 
                        

                                
for   (int   i   =   5   *   PageSequence;   i   <=   5   *   (PageSequence+1)-1;   i++
                                

                                        myDt.ImportRow(myDataSet.Tables[
0].Rows[i]); 
                                }
 
                        }
 
                        myDt.AcceptChanges(); 
                        
this.dataGridView1.DataSource   =   myDt; 
                }
 

                
private   void   timer1_Tick(object   sender,   EventArgs   e) 
                

                        TakeCount   
=   TakeCount   +   1
                        
if   (TakeCount   >   PageCount) 
                        

                                
if   (residualRowsCount   ==   0
                                

                                        TakeCount   
=   0
                                }
 
                        }
 
                        DataGrieDataBind(TakeCount); 
                }
 
        }
 
}
 
  • 1
    点赞
  • 0
    评论
  • 1
    收藏
  • 一键三连
    一键三连
  • 扫一扫,分享海报

©️2021 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值