sql更新出错，事物回滚

private  void  Save11()

         {

             SqlConnection connection = OpenSql();

             connection.Open();

             SqlTransaction tran = connection.BeginTransaction();

             try

             {

                 for  ( int  i = 0; i <= (dataGridView1.Rows.Count) - 2; i++)

                 {

                     string  sql1 =  string .Format( "insert into sqltest ( Name) values('{0}')" , dataGridView1[1, i].Value);

                     SqlCommand command =  new  SqlCommand(sql1, connection);

                     command.Transaction = tran;

                     command.ExecuteNonQuery();                  

                 }

                 tran.Commit();

             }

             catch  (Exception ex)

             {                

                 MessageBox.Show(ex.Message,  "保存失败" , MessageBoxButtons.OK, MessageBoxIcon.Error);

                 tran.Rollback();  //有错就回滚

             }

             finally             {

                 connection.Close(); connection.Dispose();

             }

         }