private DataTable GetCurrentRecord(int page)
{
DataTable dt;
if (page == 0)
{
dt = ClassDbSql.ReturnDataTable("select top " + _pageSize + " * from table_person");
}
else
{
int prePagelimit = page * _pageSize;
dt = ClassDbSql.ReturnDataTable("select top " + _pageSize +
" * from table_person where id not in(select top " + prePagelimit +
" id from table_person)");
}
try
{
dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(dt);
}
private void Form1_Load(object sender, EventArgs e)
{
// timer1.Enabled = true;
Stopwatch sw = new Stopwatch();
sw.Start();
_ds = ClassDbSql.ReturnDataSet("select * from table_person");
CalculateTotalPage();
dataGridView1.DataSource = GetCurrentRecord(1);
sw.Stop();
label1.Text = sw.Elapsed.ToString();
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
Stopwatch sw = new Stopwatch();
sw.Start();
var q = ClassDbSql.ExecuteScalar("select count(*) from table_user", new Dictionary <string, object>());
_rowCount = ((int)q.ExecuteScalar());
_totalPage = _rowCount / _pageSize;
if (_rowCount % _pageSize > 0)
{
_totalPage += 1;
}
sw.Stop();
if (label1.InvokeRequired)
{
label1.Invoke(new Action(() => label1.Text = @"TimeLoad: " + sw.Elapsed.ToString()));
}
}
private object GetCurrentRecord(int page)
{
if (page == 1)
{
_dt = ClassDbSql.ReturnDataTable("select top " + _pageSize + " * from " + NameTable);
}
else
{
var prePagelimit = (page - 1) * _pageSize;
_dt = ClassDbSql.ReturnDataTable("select top " + _pageSize + " * from " + NameTable + " where id not in(select top " + prePagelimit + " id from " + NameTable + ")");
}
try
{
dataGridView1.DataSource = _dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
return(_dt);
}
