how to link a single login page to user and admin?

",i have two databases user and admin" is this a typo or two tables?

 

Then make it one table like UserMaster and have a IsAdmin bit column which holds value as 0 - User or 1 - Admin. After successful login, based on IsAdmin value redirect to panel.

Hi

Provide a dropdown with user type and on the bases of selection of user type just validate the user and redirect the user.

OR

Create a SP in this SP first write query to check the login is for user or not if it's not then check for admin. and on the bases of the validation return the detail with the user type flag.

EG:

if exists(select * from usertable where userid=@userid and password=@password)

Begin

Select userid,name,'1' as usertable from usertable userid=@userid

End

else

if exists(select * from AdminTableb where adminid=@userid and password=@password)

Begin

Select userid,name,'2' as admintable from usertable where adminid=@userid

End