Username from multiple tables !! a project in asp.net !!?

[bhupi]

Hello there !!! Currently i am working on a live project for my department. i am using ASP.net to build a web application, to build a bulletin board type application. But currently i am struck here !! I have a login form in my application. but there are three different type of users, i.e. teachers, students, and clerk. all the information about them is placed in three different tables(and i do not want to merge these tables). now i want a common login form for all of them, and open different webpages if a student has logged in, and different web pages for teachers and clerk. now i want your help for this,to open three different type of web pages for three different type of users, using a single login form. how to do that??? try giving the answer related to dataset, datareader, or dataview !!!