事务内执行多次相同的Proc

string strcon = "server=192.168.161.170;database=OpPermissionManagement1;uid=sa;pwd=itdddd";
            string[,] ss = { { "sydy01", "zr", "123", "u10" },  {"sydy02", "zr", "123", "u10" }, { "sydy03", "zr", "123", "u10" }, { "sydy01", "zr", "123", "u10" } };

                //SP_Ma_PassWord_Insert
                using (SqlConnection con = new SqlConnection(strcon))
                {
                    con.Open();
                    SqlTransaction tran = con.BeginTransaction(IsolationLevel.ReadUncommitted);
                    SqlCommand cmd = new SqlCommand("SP_Ma_PassWord_Insert", con, tran);
                    cmd.CommandType = CommandType.StoredProcedure;
                    //cmd.Transaction = tran;
                    cmd.Parameters.Add("@SyOpID", SqlDbType.NVarChar, 16);
                    cmd.Parameters.Add("@OpName", SqlDbType.NVarChar, 20);
                    cmd.Parameters.Add("@SohoPW", SqlDbType.NVarChar, 50);
                    cmd.Parameters.Add("@Unit", SqlDbType.NVarChar, 50);
                    //cmd.ExecuteNonQuery();

                    for (int i = 0; i < 4; i++)
                    {
                        try
                        {
                            if (i == 2)
                            {
                                throw new Exception();
                            }
                            cmd.Parameters[0].Value = ss[i, 0];
                            cmd.Parameters[1].Value = ss[i, 1];
                            cmd.Parameters[2].Value = ss[i, 2];
                            cmd.Parameters[3].Value = ss[i, 3];
                            cmd.ExecuteNonQuery();

                        }
                        catch
                        {
                            tran.Rollback();
                            con.Close();
                            Console.WriteLine("err");
                            return ;
                        }
                    }
                    tran.Commit();
                    Console.WriteLine("ok");
            }