login form

How do i make a user login to member area and see only the information related to him.
I am using a sql database, the table have 3 fields. ( username, password, information).
when the user login he should only see the information coresponding to the username and password he used to loginLet the flaming begin.

Seriously though, this question has been answered at least half a million times on this board and is discussed thoroughly in several large scale articles on every single ASP.NET site on the planet.
so you're saying each user has only one database field they need to see? or is this just bad database design?
Hello, what you need is to make a login form so that users can enter their ids and passwords. then once the user is logged in, you will customize the pages according to the user logged in, check these links as a beginning:

view post 595993

regards
romans,

Don't underestimate the power of the tutorials listed on the tab at the top ( http://asp.net/Default.aspx?tabindex=3&tabid=45 ). I had an issue with a DataGrid and sorting and after spending days (almost a week) trying to find the answers on multiple ASP.NET web pages and browsing around the forums here I decided to check the tutorials (which I browsed through almost a year ago (I thinK)). I found the answer almost immediately and my page works perfect now (well, it did until I started messing around on my own... but that's a different story)

I hope you find what you're lookin for,

EYZAE