Why did David find favor in God’s sight despite his failings, while Saul ultimately did not?

Taking a census seems innocuous enough. But the underlying motive is what we should watch out for.

In today's society, giving God credit has become a foreign idea. But how did David speak of his successes?