🔒 Closed Patulong Login Form sa Visual Studio

[PHC-Minchi]

Patulong po meron na ko login form tapos connected na rin sa ms sql server gusto ko sana gumawa dalawang user for admin and cashier. pano ko kaya magagawa na pag naglogin si admin is admin form ang lalabas then kung si cashier naman naglogin lalabas is cashier form. di ko kasi magets yung tuts sa yt eh

 

[Arjienx]

retrieve mo po yung unique ID nila then store mo sa Model or declared string tapos po gamitin nyo yun pra I query yung info ng login.

 

[PHC-Minchi]

di ko magets sir

 

[dev-ace]

validate mo sa kanya kanyang credentials eh

gawa ka ng table for roles

user_table
id
name
role_id

roles_table
id
role_name

check query

SELECT email , password FROM users WHERE email = email.txt AND password = pw.txt AND role_id = 1 (Admin)
if (row >1 )
go to admin form

else
go to cashier form

 

[PHC-Minchi]

Nagawa ko na paps ganto rin nakita ko salamat salamattt

 

[Arjienx]

PHC-Minchi ang best po pag aralan MVC po search mo. Usable po yan kahit saan mas madali lng i process ang data.. pag marunong kna nyan pede mo na gamitang ng mga "Cheat like DB operations" hindi mo na kailangan pa mag insert to..


Focus po muna sa MVC increase to mastery level.. mani nlng po yang mga data.. UI nlng gagawin mo. sa sobrang dali.

 

[Arjienx]

may prob po kso yung mysql injectable po yung forms mkaka extract ka ng data kung marunong ka ng SQL Injection. na naiiwasan po ng MVC (Model View Controller)

 

[PHC-Xes]

validate mo sa kanya kanyang credentials eh

gawa ka ng table for roles

user_table
id
name
role_id

roles_table
id
role_name

check query

SELECT email , password FROM users WHERE email = email.txt AND password = pw.txt AND role_id = 1 (Admin)
if (row >1 )
go to admin form

else
go to cashier form

Patulong rin po sana

 

[PHC-Xes]

Pwede po magpatulong ano po kaya itong error na ito

tama naman po sinundan ko sa vid nito

Salamat po

 

[PHC-Xes]

Sir pwede po magpatulong paano ko po ipapasok dito yung condition na kapag equal sa admin or cs ang value ng combobox1 mag proceed po.



Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
If (String.IsNullOrEmpty(txtuser.Text) = True Or String.IsNullOrEmpty(txtpass.Text) = True) Then
MessageBox.Show("Please enter username and password")
Else
Dim con As SqlConnection = New SqlConnection("Data Source=DESKTOP-DILIAA0;Initial Catalog=mydataBase;Integrated Security=True")
con.Open()
Dim cmd As SqlCommand = New SqlCommand("Select * from TBLUSER where USERNAME='" + txtuser.Text + "' , PASSWORD='" + txtpass.Text + "'", con)
Dim sda As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim dt As DataTable = New DataTable()
sda.Fill(dt)
con.Close()

If (dt.Rows.Count > 0) Then
MessageBox.Show("Login Successful")
KANGOFORM1.Show()
Me.Hide()
Else
MessageBox.Show("Incorrect Username or Password")
txtuser.Text = ""
txtpass.Text = ""
End If
End If
End Sub