.net中事务使用方法

SqlConnection conn = new SqlConnection("server=.;database=mydb;uid=sa;pwd=");

        SqlCommand cmd = conn.CreateCommand();
        try
        {
            conn.Open();

           SqlTransaction trans = conn.BeginTransaction();

            cmd.Transaction = trans;

            cmd.CommandText = "delete from work where infocode = 'p003' ";
            cmd.ExecuteNonQuery();
            cmd.CommandText = "delete from family where infocode = 'p003' ";
            throw new Exception("error");//模拟出错
            cmd.ExecuteNonQuery();
            trans.Commit() ; //提交事务
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            trans.Rollback();//代码回滚
        }
        finally
        {
            conn.Close();

        }