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