Passing data from one form to another in C sharp

Question

Hi guys,

 I am developing a music library application in visual studio using C#. I have crated a login form which will be showing the "user form" after successful login. In the login form i am using "Id" and "Password" . In sql server database there is name related to each Ids.

 

I want to show on "User" form something like "Welcome : User Name" 

 

My question is how can I show the name on User form after logging in with ID from LogIn form . Any process to retrieve the name from sql server and show it in User form??

 

 

Please help.

 

Thank you..