He, sallallaahu ‘alayhi wa sallam, would become sad at the death of his sons and daughters:

A person who is tested with the loss of a child should know that the Prophet of Allah, sallallaahu ‘alayhi wa sallam, lost all of his children during his life, except for Faatimah who died after him.

From his guidance is that he, sallallaahu ‘alayhi wa sallam, became sad at their passing away and shed tears, but he, sallallaahu ‘alayhi wa sallam, would not say except that which pleases Allah.

Anas ibn Maalik narrated that when the Prophet’s daughter Umm Kulthoom died, he saw the Prophet of Allah, sallallaahu ‘alayhi wa sallam, sitting by the grave and he saw tears in his eyes.

These were not the tears of despair or anger at the decree of Allah. They were only tears of mercy and sadness that come from the eye of a merciful person.

Abdur-Rahmaan ibn ‘Awf (a Companion) said: “Even you, O Messenger of Allah!” So he, sallallaahu ‘alayhi wa sallam, replied: “O Ibn ‘Awf! It is  mercy.” Then he followed it with another one (i.e. another tear after the first one.) He, sallallaahu ‘alayhi wa sallam, said: “The eyes shed tears and the heart is grieved, but we do not say except what pleases our Lord. We are saddened by your departure, O Ibraaheem.”

Anas ibn Maalik said: “I have not seen anyone more merciful with children than the Prophet of Allah, sallallaahu ‘alayhi wa sallam.”

He also said: “Ibraaheem was breastfed in the area of Al-’Awaali in Madeenah and the Prophet of Allah, sallallaahu ‘alayhi wa sallam, would go to him and enter the house. The house would be filled with smoke (since the house owner was a blacksmith), so I would hurry to enter before the Prophet of Allah, sallallaahu ‘alayhi wa sallam, and say: “Abu Sayf, the Prophet of Allah, sallallaahu ‘alayhi wa sallam, has come, stop!” The Prophet of Allah, sallallaahu ‘alayhi wa sallam, would then take Ibraaheem and kiss him, then leave.”