🔒 Closed Vb.net questions

[PHC-Xes]

Pahelp po paturo po kapag po CS nasa combobox mag proceed po

 

[2pepot]

[XX='jncndlcpa, c: 1292778, m: 1832526'][/XX] welcome lodicakes

 

[Arjienx]

[XX='jncndlcpa, c: 1292780, m: 1832526'][/XX] wlang anuman..

 

[Arjienx]

[XX='2pepot, c: 1292783, m: 1443549'][/XX] yup yun din kya nga yung nilagay ko yung abot nya pra madali nya ma gets. ang important ksi jan is gumana..

 

[PHC-Xes]

[XX='Arjien, c: 1292777, m: 1773652'][/XX]
Gawa na lang po ba ko bagong database or mag add na lang po ako column?

 

[Arjienx]

[XX='Martynaustria, c: 1294831, m: 1675661'][/XX] Check mo database values kung nag match sa ilalagay mo na values.

 

[PHC-Xes]

[XX='Arjien, c: 1294856, m: 1773652'][/XX] Saan po makikita yun? Sorry youtube lang po kasi talaga sinusundan ko

 

[PHC-Xes]

Tinanggal ko na po combobox mas okay po ba na combobox or wala po nakukuha ko po kasi ito

Dim con As SqlConnection = New SqlConnection("Data Source=DESKT...

If ComboBox1.Text = "ADMIN" Then
Dim cmd As SQLCommand = New SqlCommand("Select * from TBLUSER where USERNAME..
...
...
Else
Dim cmd As SQLCommand = New SqlCommand("Select * from TBLCSUSER where USERNAME..
...
...
End If

paano po kapag wrong info nilagay paano lalagyan ng error po?

 

[PHC-Xes]

String Username;
String Password:
String Role;

Get the values of Username & Password pass them to string. reason (To prevent SQL Injection)

Actually there is simple way to create this.
Create one Database for all Users.
Username, Password, Role.

Query 1.
SELECT * FROM USERS_TBL WHERE Username="Administrator" and Password="Password" and Role="Administrator" ;
Query 2.
SELECT * FROM USERS_TBL WHERE Username="Administrator" and Password="Password" and Role="CS" ;

the best way to differentiate them is to use two different queries.
If the query one fail to get results.
you can use Query 2.
you can even remove combobox this way.

I hate to do this but this is the only close solution you can use for now.
there is more complicated way to do this. is to pass all data from users to arrays/model and do authentication by matching values using for loop.

I recommend you learn how to use classes, arrays & model. I find it hard to other student that prof don't teach this at school. you can try to ask your prof.

Thanks for calling jncndlcpa.

Fixed po ba User nito sa Administrator at Password or pwede ko po gawin ito?

SqlCommand("SELECT * FROM USERS_TBL WHERE Username='" & USERNAME & "' and Password= '" & PASSWORD & "' and ROLE='" & Administrator & "'" , con)

 

[Arjienx]

sa method ko is one database lng gagamitin. ang difference lng is may Role.

 

[Arjienx]

You can try to create that in a database. then also try the query in database.
create two users with admin/cs respectively.

pede kahit ano user/pass.

 

[PHC-Xes]

[XX='Arjien, c: 1294903, m: 1773652'][/XX] Opo nakuha ko po 1databasae tas dagdagan ko na lang ng column na ROLE

 

[PHC-Xes]

Sorry po paano ko po ipapasok dito yung

SqlCommand("SELECT * FROM USERS_TBL WHERE Username='" & USERNAME & "' and Password= '" & PASSWORD & "' and ROLE='" & Administrator & "'" , con)

Patulong po. Salamat

 

[Arjienx]

[XX='Martynaustria, c: 1294948, m: 1675661'][/XX] kulang role sa query mo. dagdagan mo.
tapos dagdagan mo ng role sa rows count.

if role = "admin" {

}
else{

}

 

[PHC-Xes]

[XX='Arjien, c: 1294953, m: 1773652'][/XX]
Paturo naman po di ko po alam saan ko ipapasok yang if role ="ADMIN"

Salamat po

 

[Arjienx]

[XX='Martynaustria, c: 1295012, m: 1675661'][/XX]

String a = user.txt
String b = pass.txt
String c = role.txt
SqlCommand("SELECT * FROM USERS_TBL WHERE Username= a and Password=b and ROLE=c " , con)
if (dt.Rows.Count > 0){

If c.txt = "Admin"{
admin form.
}
if c.txt = "cs"{
cs form.
}
}

 

[PHC-Xes]

[XX='Arjien, c: 1295213, m: 1773652'][/XX]
2 forms lang po talaga gagawin ko dito 1st login form then 2nd is search form bale lalagyan ko lang restriction si CS limited access possible po ba yun?

 

[Arjienx]

[XX='Martynaustria, c: 1295857, m: 1675661'][/XX] create separate forms for each of them.

 

[PHC-Xes]

Yung ROLE=c po ba dito sa tinuturo nyo textbox? iinput pa role sa login form? parang mas okay yata yung combobox kesa iencode pa admin/cs

 

[Arjienx]

[XX='Martynaustria, c: 1296382, m: 1675661'][/XX] pede din ikaw bahala.

 

[PHC-Xes]

Patulong po Sir