How to select & store column values from MS SQL DB

Question

in my case, i am entering USER ID. and then I want to select the EMAIL ID and PASSWORD field values of the particular user and store them to the variable (in C#).