Hi, can I ask help? What I am going to do? I want a login form based on there usertype or role in Microsoft C# using Microsoft access database

See more:

C#

I dont know how to Code it.i dont know how to login based on users Roles

What I have tried:

try
{
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\dhdum\Documents\Ediwow.mdb;Persist Security Info= False";
connection.Open();
OleDbCommand command = new OleDbCommand();
command.Connection = connection;
command.CommandText = "SELECT UserType FROM Table1 WHERE User ='" + textBox1.Text.Trim() + "' AND Password = '" + textBox2.Text + "'" ; ;

OleDbDataReader reader = command.ExecuteReader();





int Count = 0;
while (reader.Read())
{
Count = Count + 1;
}
if(dt.Rows.Count > 0)
UserType = dt.Rows[0]["UserType"].ToString().Trim();
if (textBox1.Text == "Admin" && textBox2.Text =="Admin")
{
MessageBox.Show("Welcome Admin");
connection.Close();
this.Hide();
ADMIN_PAGE ADMIN_PAGE = new ADMIN_PAGE();
ADMIN_PAGE.ShowDialog();
}


if (UserType == "Admin")
{

MessageBox.Show("Welcome Teahcer");

connection.Close();
this.Hide();
TEACHER_START_UP TEACHER_START_UP = new TEACHER_START_UP();
TEACHER_START_UP.ShowDialog();



}
else
MessageBox.Show("Username or Password do not match");
textBox1.Text = "";
textBox2.Text = "";
textBox1.Focus();
connection.Close();


}
catch (Exception ex)
{
MessageBox.Show("Error" + ex);
connection.Close();



}
}