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