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);
}
}
}
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);
}
}
}