更新失败,失败缘故:SqlConnection 不支持并行事务

更新失败,失败原因:SqlConnection 不支持并行事务。
protected void Button2_Click(object sender, EventArgs e)
  {
  //连接字串"SqlConnString" 写到配置文件(web.config)中
  SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connkeji"].ConnectionString);
  conn.Open();
  SqlTransaction tran = null;
  try
  {
   

  for (int i = 0; i < GridView2.Rows.Count; i++)
  {
  string sqlStr = "";
  SqlCommand comm = new SqlCommand();
  tran = conn.BeginTransaction();

  string strname = GridView2.Rows[i].Cells[0].Text.Trim().ToString();
  string strpassword = GridView2.Rows[i].Cells[1].Text.Trim().ToString();
  string strqq = GridView2.Rows[i].Cells[2].Text.Trim().ToString();
  string stremail = GridView2.Rows[i].Cells[3].Text.Trim().ToString();
  string strphone = GridView2.Rows[i].Cells[4].Text.Trim().ToString();

  sqlStr += "INSERT my_user(user_name,user_password,user_qq,user_email,user_phone) VALUES ('" + strname + "','" + strpassword + "','" + strqq + "','" + stremail + "','"+strphone+"');";

   
  comm.CommandText = sqlStr;
  comm.Connection = conn;
  comm.Transaction = tran;
  comm.ExecuteNonQuery();
  }

  }
  catch (Exception ex)
  {
  Response.Write("更新失败,失败原因:" + ex.Message);
  tran.Rollback(); //事务回滚
  }
  finally
  {
  conn.Close();
  }
  }

[解决办法]

C# code

        public int ExecuteNonQuery(List<string> strSQL)        {            int index = 0;            CheckConnection();            //SqlCommand com = new SqlCommand(strSQL, con);            using (SqlCommand cmd = con.CreateCommand())            {                SqlTransaction tran = con.BeginTransaction();                cmd.Transaction = tran;                try                {                    foreach (string item in strSQL)                    {                        cmd.CommandText = item;                        cmd.ExecuteNonQuery();                    }                    tran.Commit();//如果都成功那么提交事物                }                catch (Exception ex)                {                    index = -1;                    //throw new Exception(ex.Message);                    tran.Rollback();                }                //index = com.ExecuteNonQuery();            }            return index;        }        public void CheckConnection()        {            if (this.con.State == ConnectionState.Closed)            {                this.con.Open();            }        }
[解决办法]
3楼说的对,没注意循环
[解决办法]
探讨 
 
你那个里，也没有事务的commit
参照：

C# code

        public int ExecuteNonQuery(List<string> strSQL)
        {
            int index = 0;
            CheckConnection();

            //SqlCommand com = ne……

[解决办法]
你到底想创建多少个失误（事务）？
一次执行只要一个事务，但是你把事务的创建过程放到循环里去了，也就是创建了很多事务，这样不出错就奇怪了，和并行不并行无关，你根本就不会用事务，还不如不要用。