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