Hi thr!!!!!!
i hav 3 tables named users with fields uid, Rollid , username n password. 2nd table Rolls with fields Rollid and Roll type.Here rolltype is Admin and Staff. and 3rd table Access with fields Id,RollId,Pagename. I hav a .aspx page which contains user name , password and a login button. nw wen i click on login in roll table it should check for roll type and watever is the roll type it should check for username and password for that rollid in users table in database and if the username and password is valid then the user should redirected to the page that has been in Acces table.
Like if the roll type is Admin then it'll check for username and password and if iits valid then the admin user'll b redirected to page according to Access Table.
Go to the complete details ...