Retrieving filtered data

I'm currently using the login feature that came with the default MVC 3 layout.

I have no problem with regards to writing the data using the default pages that i edited. My problem is how to view the data.

So I having trouble with 2 things.
1. How to do something similar to "SELECT * FROM UserRecord WHERE username = *the current logged user*"?
2. How to transfer the retrieved data to individual textboxes?

I'm working with C# btw.

HttpContext.Current.User