private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = SqlDataHelper.GetConnection();
Stopwatch sw = new Stopwatch();
string sqlstr = "select top 10 * from TestTab";
sw.Start();
conn.Open();
DataSet ds = SqlDataHelper.ExecuteDataSet(conn, CommandType.Text, sqlstr);
conn.Close();
sw.Stop();
MessageBox.Show("ds:" + sw.Elapsed.TotalMilliseconds);
Stopwatch sw2 = new Stopwatch();
sw2.Start();
conn.Open();
DataTable dt = SqlDataHelper.ExecuteDataTable(conn, sqlstr, null);
conn.Close();
sw2.Stop();
MessageBox.Show("dt:" + sw2.Elapsed.TotalMilliseconds);
Stopwatch sw3 = new Stopwatch();
sw3.Start();
conn.Open();
DataTable dtt = new DataTable();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
SqlDataReader sdr = cmd.ExecuteReader();
dtt.Load(sdr);
conn.Close();
sw3.Stop();
MessageBox.Show("sdr:" + sw3.Elapsed.TotalMilliseconds);
}
static void Main(string[] args)
{
SqlDataHelper.SetConnStr("127.0.0.1", "1433", "TestDB", "sa", "123");
SqlConnection conn = SqlDataHelper.GetConnection();
string sqlstr = "select top 100000 * from TestTab";
double d = 0;
// d = 0;
// for (int i = 0; i < 100; i++)
// {
// Stopwatch sw = new Stopwatch();
//
// sw.Start();
// conn.Open();
// DataSet ds = SqlDataHelper.ExecuteDataSet(conn, CommandType.Text, sqlstr);
// conn.Close();
// sw.Stop();
// d = d + sw.ElapsedMilliseconds;
// Console.WriteLine($"ds{i}:" + sw.Elapsed.TotalMilliseconds);
// }
// Console.WriteLine("ds Total:" + (d / 100.0).ToString());
// Console.WriteLine();
d = 0;
for (int i = 0; i < 100; i++)
{
Stopwatch sw2 = new Stopwatch();
sw2.Start();
conn.Open();
DataTable dt = SqlDataHelper.ExecuteDataTable(conn, "SelectTest", CommandType.StoredProcedure, null);
conn.Close();
sw2.Stop();
d = d + sw2.ElapsedMilliseconds;
Console.WriteLine($"dt{i}:" + sw2.Elapsed.TotalMilliseconds);
}
Console.WriteLine("dt Total:" + (d / 100.0).ToString());
Console.WriteLine();
d = 0;
for (int i = 0; i < 100; i++)
{
Stopwatch sw = new Stopwatch();
sw.Start();
conn.Open();
DataSet ds = SqlDataHelper.ExecuteDataSet(conn, CommandType.StoredProcedure, "SelectTest");
conn.Close();
sw.Stop();
d = d + sw.ElapsedMilliseconds;
Console.WriteLine($"ds{i}:" + sw.Elapsed.TotalMilliseconds);
}
Console.WriteLine("ds Total:" + (d / 100.0).ToString());
Console.WriteLine();
// d = 0;
// for (int i = 0; i < 100; i++)
// {
// Stopwatch sw2 = new Stopwatch();
// sw2.Start();
// conn.Open();
// DataTable dt = SqlDataHelper.ExecuteDataTable(conn, sqlstr, CommandType.Text, null);
// conn.Close();
// sw2.Stop();
//
// d = d + sw2.ElapsedMilliseconds;
// Console.WriteLine($"dt{i}:" + sw2.Elapsed.TotalMilliseconds);
// }
// Console.WriteLine("dt Total:" + (d / 100.0).ToString());
// Console.WriteLine();
// d = 0;
// for (int i = 0; i < 10; i++)
// {
// Stopwatch sw3 = new Stopwatch();
// sw3.Start();
// conn.Open();
// DataTable dtt = new DataTable();
// SqlCommand cmd = new SqlCommand(sqlstr, conn);
// SqlDataReader sdr = cmd.ExecuteReader();
// dtt.Load(sdr);
// conn.Close();
// sw3.Stop();
//
// d = d + sw3.ElapsedMilliseconds;
// Console.WriteLine($"sdr{i}:" + sw3.Elapsed.TotalMilliseconds);
// }
// Console.WriteLine("sdr Total:" + (d / 10.0).ToString());
// Console.Read();
}