login code of asp.net with sqlserver

Question

hi,im jyothi

im a beginer in dotnet,in my project i have three different types of users like administrator,user,member.i think i have to create three tables.

how can i use those tables using stored procedure and login through asp.net.

when i login with administrator it should open adminstrator's page

when i login with member it should open member page.

when i login with user it should open user's page

plz send me the code