I have 3 Users and I have a different environment for each. How do I code that in my initial form(login form)?
I need help:
My sample
If dr.Read=true then
Dim adp as New OleDbDataAdapter("Select * From tblUSer WHERE Security_Profile='User 1'","PATH")
Dim dt as New DataTable
adp.Fill(Dt)
Homepage.Show()
Homepage.Button1.Enabled=False
Form3.GroupBox1.Enabled=False
Form3.GroupBox1.Enabled=False
Form3.GroupBox1.Enabled=False
Elseif dr.Read=true then
Dim adp as New OleDbDataAdapter("Select * From tblUSer WHERE Security_Profile='User 2'","PATH")
Dim dt as New DataTable
adp.Fill(Dt)
Homepage.Show()
Form3.GroupBox1.Enabled=False
Form3.GroupBox1.Enabled=True
Form3.GroupBox1.Enabled=False
Elseif dr.Read=true then
Dim adp as New OleDbDataAdapter("Select * From tblUSer WHERE Security_Profile='User 3'","PATH")
Dim dt as New DataTable
adp.Fill(Dt)
Homepage.Show()
Form3.GroupBox1.Enabled=False
Form3.GroupBox1.Enabled=True
Form3.GroupBox1.Enabled=True
Can somebody please help?I don't know how to limit it by user.