Was King David Faithful to God in the Bible?

Was King David Faithful to God in the Bible? The relationship between King David