Exemple #1
0
        private void DB_select_DoWork(object sender, DoWorkEventArgs e)
        {
            try
            {
                BackgroundWorker worker = sender as BackgroundWorker;

                GlobalData.query_argument args = e.Argument as GlobalData.query_argument;

                swatch.Start();

                DataTable dt;

                dt = DB_control.DB_SELECT(args);

                swatch.Stop();
                string query_speed = Math.Round(Convert.ToDouble(swatch.ElapsedMilliseconds / 1000), 2).ToString();
                swatch.Reset();

                swatch.Start();
                dgv_selectData.Invoke((MethodInvoker) delegate()
                {
                    dgv_selectData.DataSource = dt;

                    dgv_selectData.Columns[0].DefaultCellStyle.Format = "yyyy/MM/dd HH:mm:ss";

                    dgv_selectData.Update();
                });
                swatch.Stop();
                string ui_speed = Math.Round(Convert.ToDouble(swatch.ElapsedMilliseconds / 1000), 2).ToString();

                lb_Query_speed.Invoke((MethodInvoker) delegate()
                {
                    lb_Query_speed.Text = query_speed + " s, " + ui_speed + " s "
                                          + dt.Rows.Count.ToString() + " 행";
                });

                swatch.Reset();

                this.Invoke((MethodInvoker) delegate()
                {
                    loading.Close();
                });


                GC.Collect();
            }
            catch (Exception ex)
            {
                Log("[" + ex.ToString() + "]" + DateTime.Now);
            }
        }