Was the Holy Spirit was upon him even as he murdered another man so he could take the other man's wife in adultery ?
Your Bible disagrees with mine. Either that or you are again injecting your own opinion into the Bible account. David did not murder another man. That man, Uriah, was a warrior, and he died in battle as an honorable man, serving his king. While David asked Uriah's commander to put him at the forefront of the battle, you do not know that Uriah might have died in any case. For one reason or another, God wanted Uriah dead at that point. Are you saying that God could not have saved Uriah and brought him back to his wife?
The case was that Satan, the god of this world, provided the progenitor of Joseph and Mary a situation testing his obedience to God. If David had listened to the guidance of the Holy Spirit rather than the urging of his pecker, he would still have been Bathsheba's husband, yet without sinning by anticipating Uriah's death but instead, joining with Bathsheba after she became a widow. In any case, David's sin with Bathsheba was found out. He could hide it neither from God nor man. David was a sinner: saved, but still a sinner. Yet, being saved, he had an option--obey God or obey your own lusts. In it all, The God of the Bible, through Paul, proclained David as a man "after His own heart" (Acts 13:22) David was a sinner, and when He was guided by the Holy Ghost, the writer of a large portion of the longest book in the Bible.
God saves sinners. Before their redemption, humans stained with the crime of their father Adam have no power over their bent to give in to sin. They are not sinners because they sin--they sin because they are sinners.
Sinners who are saved also are tempted to sin, as Jesus was in the beginning of His ministry. And though Jesus by victory over death has broken the power of sin as a master, though they are regenerated with the indwelling Spiritual Advisor, and though they have the clear ability to choose the right thing to do and make that choice stick, sometimes they ignorantly or willingly through spiritual immaturity choose otherwise, and they do err.
When that happens, they are faced with another choice: do I humble myself, confess my sin, and repent, being forgiven by the Faithful, Just Father, and be cleansed of all unrighteousness; and go on walking in the light? or do I cling to my pride, reject The Counselor's urging, and go on walking in the dark, out of fellowship with God and other Christians?
David chose the former and was renewed in fellowship with The Father. More than once.
What about you? In the statement above, you make God's Word to be a lie, by calling David a murderer.
"If we say that we have not sinned, we make him a liar, and his word is not in us" (1 Jn. 1:10 AV).
Now, if I sin, I have an Advocate with the Father, Jesus Christ The Righteous One. But I know that there is another power, the prince of the air, who has his opwn advocates. You're not one of those, are you? Have you ever sinned? Have you ever looked on a woman with lust in your heart? Come on now, confess. If you have, or looked on an acquaintance with murder in your eye, wishing he/she were dead, you're no different than David.
The beam, man, the beam.
Who is telling the truth in this matter, you or I? (God will judge.)
One of us is not in fellowship with the Christ of The Bible, guided by His Spirit the Comforter, and proclaiming His Gospel as a herald, an unashamed workman, rightly dividing the Word of The Truth. One of us is walking in the dark.
Was the Holy Spirit was upon him even as he murdered another man so he could take the other man's wife in adultery ?
Was the Holy Spirit upon Peter who cut off a soldier's ear?
Was the Holy Spirit upon Paul who was in favor of the stoning of Stephen?
Was David called a man after God's own heart?
A simple yes or no to each question will suffice.