Help Vb.net questions

[PHC-Xes]

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

 

[Starrdust]

Arjien
2pepot

 

[PHC-Xes]

Salamat po

 

[kamotEgg]

pa mark po

 

[PHC-Xes]

Sige lang po

 

[PHC-Xes]

2 sql database po kapag po ADMIN sa TBLUSER po sya kukuha ng access user and kapag naman po CS sa TBLCSUSER naman po. Salamat po

 

[kamotEgg]

ano ba gusto mo gawin sir pag click ng cs direcho sa form2?

 

[PHC-Xes]

may 2 database po ako para sa user isang admin at cs role of access.

 

[PHC-Xes]

parehas po mag process sa form2 bale po gusto ko lang sana magkahiwalay ng database na pagkukunan

 

[kamotEgg]

medyo namiss ko to eto inaral ko pero hindi naman ito trabaho ko sayang

 

[PHC-Xes]

[XX='kamotEgg, c: 1292449, m: 1867350'][/XX]
Same Sir nakahiligan ko rin po pero sa katagalan na nakalimutan na rin

 

[Arjienx]

no..

 

[PHC-Xes]

[XX='Arjien, c: 1292694, m: 1773652'][/XX] Ano pong no?

 

[Arjienx]

[XX='Martynaustria, c: 1292765, m: 1675661'][/XX] wrong. di ganyan. papagalitan ka ng prof mo pag gnawa mo yan.

 

[2pepot]

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

 

[Arjienx]

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.

 

[Arjienx]

wow. we got it answered at a same time tho. but I don't recommend using combobox. you can remove them and add role query to sql database.

 

[Starrdust]

Thank you lodicakes.

 

[Starrdust]

Thank you

 

[2pepot]

[XX='Arjien, c: 1292777, m: 1773652'][/XX] medyo beginner palang yata sya bro, hayaan muna natin sa basic conditional statements, matututo din yan sa advanced lessons nya ng secured coding..