01.
Imports
System.Data
02.
Imports
System.Data.OleDb
03.
Module
Module1
04.
Public
con
As
OleDbConnection
05.
Public
da
As
OleDbDataAdapter
06.
Public
ds
As
DataSet
07.
Public
cmd
As
OleDbCommand
08.
Public
rd
As
OleDbDataReader
09.
Public
str
As
String
10.
11.
Public
Sub
connection()
12.
str =
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\admim\Documents\ฐานข้อมูล5.accdb"
13.
con =
New
OleDbConnection(str)
14.
If
con.State = ConnectionState.Closed
Then
15.
con.Open()
16.
End
If
17.
End
Sub
18.
End
Module
19.
20.
Public
Class
frmlogin
21.
22.
Private
Sub
Login_Load(sender
As
Object
, e
As
EventArgs)
Handles
MyBase
.Load
23.
24.
End
Sub
25.
26.
Private
Sub
Button1_Click(sender
As
Object
, e
As
EventArgs)
Handles
Button1.Click
27.
connection()
28.
If
(txtuser.Text =
""
)
Then
29.
MessageBox.Show(
"กรุณากรอกUsername"
,
"Login"
, MessageBoxButtons.OK, MessageBoxIcon.Warning)
30.
txtuser.Focus()
31.
Exit
Sub
32.
End
If
33.
34.
If
(txtpass.Text =
""
)
Then
35.
MessageBox.Show(
"กรุณากรอกPassword"
,
"Login"
, MessageBoxButtons.OK, MessageBoxIcon.Warning)
36.
txtpass.Focus()
37.
Exit
Sub
38.
End
If
39.
40.
If
txtuser.Text =
"user1"
And
txtpass.Text =
"1234"
Then
41.
MessageBox.Show(
"คุณคือ user1"
,
"Login"
, MessageBoxButtons.OK)
42.
Call
user1login()
43.
ElseIf
txtuser.Text =
"user2"
And
txtpass.Text =
"4567"
Then
44.
MessageBox.Show(
"คุณคือ user2"
,
"Login"
, MessageBoxButtons.OK)
45.
Call
user2login()
46.
ElseIf
txtuser.Text =
"user3"
And
txtpass.Text =
"7890"
Then
47.
MessageBox.Show(
"คุณคือ user3"
,
"Login"
, MessageBoxButtons.OK)
48.
Call
user3login()
49.
Else
50.
MsgBox(
"username หรือ password ไม่ถูกต้อง"
)
51.
52.
End
If
53.
End
Sub
54.
55.
Private
Sub
user1login()
56.
Dim
frmpro
As
New
frmproject
57.
frmproject.Show()
58.
Me
.Hide()
59.
frmpro.ToolStripButton1.Visible =
True
60.
frmpro.ToolStripButton2.Visible =
False
61.
frmpro.ToolStripButton3.Visible =
False
62.
frmpro.ToolStripButton4.Visible =
True
63.
64.
End
Sub
65.
66.
Private
Sub
user2login()
67.
Dim
frmpro
As
New
frmproject
68.
frmproject.Show()
69.
Me
.Hide()
70.
frmpro.ToolStripButton1.Visible =
False
71.
frmpro.ToolStripButton2.Visible =
True
72.
frmpro.ToolStripButton3.Visible =
False
73.
frmpro.ToolStripButton4.Visible =
True
74.
End
Sub
75.
76.
Private
Sub
user3login()
77.
Dim
frmpro
As
New
frmproject
78.
frmproject.Show()
79.
Me
.Hide()
80.
frmpro.ToolStripButton1.Visible =
False
81.
frmpro.ToolStripButton2.Visible =
True
82.
frmpro.ToolStripButton3.Visible =
True
83.
frmpro.ToolStripButton4.Visible =
True
84.
End
Sub
85.
86.
Private
Sub
Button2_Click(sender
As
Object
, e
As
EventArgs)
Handles
Button2.Click
87.
If
MessageBox.Show(
"คุณต้องการออกจากระบบ?"
,
"Login"
, MessageBoxButtons.YesNo) = DialogResult.Yes
Then
88.
Application.
Exit
()
89.
End
If
90.
91.
92.
End
Sub