timer计时器问题

Question

下面的代码执行时，timer和for循环怎么不是同步执行呢
private void button3_Click(object sender, EventArgs e)
        {
            timer1.Interval = 50;
            progressBar1.Value = 0;
            timer1.Enabled = true;
            timer1.Start();
            
            for (int i = 0; i < 476; i++)
            {
                
                for (int j = 1; j < 78; j++)
                {
                    
                    int id = 3888 + i;
                    string Station = "Station" + j;
                    string sqlselect = "select "+Station+" from BusStationRowG where id="+id;
                    SqlCommand comm2 = new SqlCommand(sqlselect, Consql.con);
                    Consql.con.Open();
                    SqlDataReader reader = comm2.ExecuteReader();
                    reader.Read();
                    if (reader[0].ToString() =="")
                    {
                        Consql.con.Close(); 
                    }
                    else
                    {
                        Consql.con.Close(); 
                        string sql = "Insert into BusStationColumn(BusNo,Station) select BusNo," + Station + " from BusStationRowG where id=" + id;
                        try
                        {
                            SqlCommand comm = new SqlCommand(sql, Consql.con);
                            Consql.con.Open();
                            comm.ExecuteNonQuery();
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        finally
                        {
                            Consql.con.Close();
                        }
                       
                    }
                   
                }
            }
                       MessageBox.Show("完成1！");
        }
        private void timer1_Tick(object sender, EventArgs e)
        {
            progressBar1.Value += 1;
            if (progressBar1.Value >= 100)
            {
                timer1.Stop();
                MessageBox.Show("完成2！");
                
            }
        }
我实行边执行往数据库中加数据，滚动条边前进，当数据填完时，滚动条也结束，跳出对话框提示完成，应该怎么改呀，求解！

Answer 1

ProgressBar会消耗大概4950ms完成，但向数据库中加数据却不能保证一定也消耗同样的时间，当然不同步了。

Answer 2

要实现你说的效果 用多线程就能实现
比如：Thread th=new Thread(new ThreadStart(方法名不要小括号));
th.start();
在方法里面 滚动条的value++

Answer 3

你的这个Timer需要等到for循环执行完才会触发

Answer 4

因为你只有一个线程在做着事情这种长时间的处理，不能放在button的时间里，否则会导致界面卡死应该用异步来做这种事情，如果用了异步，那么进度条的问题就自然而然解决了        private void button1_Click(object sender, EventArgs e) {
            new Thread(work).Start();
        }        private void work()
        {
            for (int i = 0; i < 100; i++)
            {
                // 用sleep替代你的费时的操作
                Thread.Sleep(100);
                // 操作完成之后更新UI
                this.Invoke(new Action(notify));
            }
        }        private void notify()
        {
            this.progressBar1.Value++;
        }