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); 
                }
 
        }
 
}
 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值