private void button1_Click(object sender, EventArgs e) { try { labelInfo.Text = ""; TimeSpan ts = new TimeSpan(); string dbType = comboBoxDbType.Text; string sql = textBoxSql.Text; int pageSize = (int)numericUpDownPageSize.Value; int pageIndex = (int)numericUpDownPageIndex.Value; int start = (pageIndex - 1) * pageSize + 1; DataTable dt = new DataTable(); using (BDBHelper dbHelper = new BDBHelper(dbType, textBoxConn.Text)) { DateTime begin = DateTime.Now; dt = dbHelper.ExecuteDataTablePageWithReader(sql, pageSize, pageIndex); ts = DateTime.Now - begin; } dataGridView1.DataSource = dt; labelTime.Text = ts.TotalMilliseconds + "毫秒"; labelInfo.Text = "返回时间:" + DateTime.Now.ToString(); } catch (Exception ex) { labelInfo.Text = ex.Message; } }