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