in my database having three tables
1) Empoyee Master
2) Login Master
3) Department Master
in login and department master have column for Department id is DeptID but in employee master has name of Department.
exp.
Employee Master
Emp Name Emp Salary Emp Department
XYZ 10,000 Account ETC.
Login Master
USER NAME PASSWORD DEPTID
QPR 123 121
ASD 110 120
Department Master
Department Name DEPTID
ACCOUNT 121
HR 120
now i want to display only account related data when user login in system...
on employee page only data should be display relevant department
using asp.net web application......
how to do this please help me to solve this.....