multiple login with 3 table (lecturer,student,role) asp c#

Hye I have a login form that has username and password textbox. I also have 2 radio button for 2 role which is Lecturer and Student.

For the table in the database, I have Staff table(Lecturer), Student table and Position table(role).

The problem is I don't know how to make when the user enters username and password and choose one role for example lecturer, the username and password will enter the lecturer table and vice versa.

I hope I can get some tips and clues from here and I'm sorry if this question sounds dumb but I don't know what to do anymore.

Here is the interface for login page:

Sql for table Staff

CREATE TABLE [dbo].[Staffs] (

[StaffsID] INT NOT NULL,

[StaffName] NCHAR (10) NOT NULL,

[StaffPw] NCHAR (10) NOT NULL,

[UpdatedBy] NCHAR (10) NULL,

[UpdatedOn] DATETIME NULL,

[PositionID] NCHAR (10) NOT NULL,

PRIMARY KEY CLUSTERED ([StaffsID] ASC),

CONSTRAINT [FK_Staffs_PositionID] FOREIGN KEY ([PositionID]) REFERENCES [dbo].[Positions] ([PositionID])

);

SQL for table student

CREATE TABLE [dbo].[Students] (

[StudID] INT NOT NULL,

[StudName] NCHAR (10) NULL,

[StudPw] NCHAR (10) NULL,

[StudEmail] NCHAR (10) NULL,

[UpdatedOn] DATETIME NULL,

[UpdatedBy] NCHAR (10) NULL,

PRIMARY KEY CLUSTERED ([StudID] ASC)

);

SQL for table position

CREATE TABLE [dbo].[Positions] (

[PositionID] NCHAR (10) NOT NULL,

[PositionName] NCHAR (10) NULL,

PRIMARY KEY CLUSTERED ([PositionID] ASC)

);

Hi,

From your question what I understand is you have created Student table, Staff table and Position table. Based on the User Role you are storing user details in these respective tables. Here you mentioned that if Student tries to login, you are validating those login credentials with data available in your Student table. If staff login you are doing validation with data available in Staff table.

Here, I want to suggest you a simplistic approach, you have created seperate tables. Based on the roles you can use those tables to store user's master data like name and other info as it is. But I wanted to suggest you that do not store login credentials in those seperate tables. Instead of that, create seperate Login table in your database to store login credentials of all users irrespective of user's role. So this will help you to simplify your login process and every time any user wanted to login you can validate user credentials against single login table.

I hope this will help you.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir7y ago
Hi,

From your question what I understand is you have created Student table, Staff table and Position table. Based on the User Role you are storing user details in these respective tables. Here you mentioned that if Student tries to login, you are validating those login credentials with data available in your Student table. If staff login you are doing validation with data available in Staff table.

Here, I want to suggest you a simplistic approach, you have created seperate tables. Based on the roles you can use those tables to store user's master data like name and other info as it is. But I wanted to suggest you that do not store login credentials in those seperate tables. Instead of that, create seperate Login table in your database to store login credentials of all users irrespective of user's role. So this will help you to simplify your login process and every time any user wanted to login you can validate user credentials against single login table.

I hope this will help you.