What is the Du`a (supplication) of Istikhara (guidance prayer)?
O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."
What is the ruling on attending relatives` parties held in public halls, or hotels since if we don`t, we will be subjected to their admonition?
If such parties involve mixing between men and women, or forbidden acts such as listening to songs with sinful lyrics, then attending them is forbidden from the view point of Sharia since people`s admonition is nothing compared to Allah`s, The Almighty`s, wrath.
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
Is the father a Mahram (Non-marriageable) to his son`s mother-in-law?
The father is a non-Mahram (Marriageable) to his son`s mother-in-law, so it is impermissible for them to look at each other, or to have a seclusion (Khalwah).