请教多线程进行数据库更新

Question

这个是我写的代码，可是执行程序会卡死private void button4_Click(object sender, EventArgs e)
{
   Random rnd = new Random();
                try
                {
                    using (SqlConnection conn = DBOper.CaertConn("UserDB"))
                    {
                        conn.Open();
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection = conn;
                        for (int i = 1; i <= 100000; i++)
                        {
                            cmd.CommandText = string.Format("update dbo.AccountsInfo set FaceID = {0} where UserID ={1}", rnd.Next(1, 29), i);
                            cmd.ExecuteNonQuery();
                        }
                        conn.Close();
                    }
                    MessageBox.Show("更新完成！");
                }
                catch (Exception)
                {
                    MessageBox.Show("更新失败！");
                }
}
麻烦大家教教我 怎么用多线程解决啊？麻烦给出实际代码，我对多线程完全不了解，谢谢

Answer 1

for (int i = 1; i <= 100000; i++)
                        {
                            cmd.CommandText = string.Format("update dbo.AccountsInfo set FaceID = {0} where UserID ={1}", rnd.Next(1, 29), i);
                            cmd.ExecuteNonQuery();
                        }
要不加上sleep，另外可以每10000个更新组织成一个串，调用一次写库。

Answer 2

ThreadPool.QueueUserWorkItem(new WaitCallback(Write),null);    public void Write(Object obj)
{
  using (SqlConnection conn = DBOper.CaertConn("UserDB"))
                    {
                        conn.Open();
                        SqlCommand cmd = new SqlCommand();
                        cmd.Connection = conn;
                        for (int i = 1; i <= 100000; i++)
                        {
                            cmd.CommandText = string.Format("update dbo.AccountsInfo set FaceID = {0} where UserID ={1}", rnd.Next(1, 29), i);
                            cmd.ExecuteNonQuery();
                        }
                        conn.Close();
                    }}

Answer 3

我试验了下···我改成这样了就还是卡死，因为我要弹出一个窗体提示
ShowState ss = new ShowState();
ss.ShowDialog();
ThreadPool.QueueUserWorkItem(new WaitCallback(UpdateAllFace), null);
ss.Close();

Answer 4

用BackgroundWorker控件，把执行的代码放到其中的DoWork事件中

Answer 5

 new Thread(() =>
                           {
                               Random rnd = new Random();
                               try
                               {
                                   using (SqlConnection conn = DBOper.CaertConn("UserDB"))
                                   {
                                       conn.Open();
                                       SqlCommand cmd = new SqlCommand();
                                       cmd.Connection = conn;
                                       for (int i = 1; i <= 100000; i++)
                                       {
                                           cmd.CommandText = string.Format("update dbo.AccountsInfo set FaceID = {0} where UserID ={1}", rnd.Next(1, 29), i);
                                           cmd.ExecuteNonQuery();
                                       }
                                       conn.Close();
                                   }
                                   MessageBox.Show("更新完成！");
                               }
                               catch (Exception)
                               {
                                   MessageBox.Show("更新失败！");
                               }
                           }).Start();