private async void btnMerge_Click(object sender, EventArgs e)
{
Random rand = new Random();
Bulk BULK = new Bulk();
var number = string.IsNullOrEmpty(txtNum.Text) ? 500 : Convert.ToInt32(txtNum.Text);
var data = BULK.GenerateData(number);
var top100 = BULK.SelectTop100();
foreach (DataRow row in top100.Rows)
{
var newRow = data.NewRow();
newRow["NAME"] = row["NAME"];
newRow["PRICE"] = rand.Next(1, 1000000);
data.Rows.Add(newRow);
}
var watch = System.Diagnostics.Stopwatch.StartNew();
await BULK.MergeData("#TEMPBULKCOPY", "BULKCOPY", data);
watch.Stop();
TimeSpan t = TimeSpan.FromMilliseconds(watch.ElapsedMilliseconds);
string time = string.Format("{0:D2}h:{1:D2}m:{2:D2}s:{3:D3}ms",
t.Hours,
t.Minutes,
t.Seconds,
t.Milliseconds);
lblResult.Text = string.Format("Merge {0} record complete in {1}", data.Rows.Count, time);
}
private void btnInsert_Click(object sender, EventArgs e)
{
Bulk bulk = new Bulk();
var number = string.IsNullOrEmpty(txtNum.Text) ? 500 : Convert.ToInt32(txtNum.Text);
var data = bulk.GenerateData(number);
var tableName = "BULKCOPY";
var watch = System.Diagnostics.Stopwatch.StartNew();
var result = bulk.InsertBulk(data, tableName);
watch.Stop();
TimeSpan t = TimeSpan.FromMilliseconds(watch.ElapsedMilliseconds);
string time = string.Format("{0:D2}h:{1:D2}m:{2:D2}s:{3:D3}ms",
t.Hours,
t.Minutes,
t.Seconds,
t.Milliseconds);
if (result)
{
lblResult.Text = string.Format("Insert {0} record complete in {1} miliseconds", data.Rows.Count, time);
}
else
{
lblResult.Text = "Insert Fail.";
}
}
