Connect VB.net Combobox to MySQL...

[NeoneedsaPC]

Hi.I have following Scenario:

I have a Database with:|ID|Class|Name|LastName|Password|
Now i would like VB.net to first connect and combine Name and Lastname and output it to a list with the ID and Class behind it.Now,the User has a ComboBox.He selects his Class.Then his Name and Last Name will be shown in a second Combobox,and he can select that too.Then,he will enter his Password to a Textbox.If its correct,log him in.If not,go back to 1.
So lets say i have:
|1|7|Neo|Whatever|mypassword|
|1|6|Bugi|whatever|hispassword|

now i want VB.net to combine Neo and Whatever to 1 seperated String and Bugi and whatever to a seperated String stored in a Array.Then i set my Class to be 7. Only I am shown,But when i select 6,only he is shown.Then,depending on if i want to login or him,we enter our password.It compares it and runs my Login code,else,it goes back to 1.

Can someone provide me some Code?I never worked with MySQL Integration before.
Admin or Mod,please move it to the correct Section.I couldnt find it and MySQL can be called Networking...

 

[kanewolf]

We don't do peoples homework here. Sorry.

 

[rgd1101]

sql is sql, just need connection string to connect to them.
a google give me this for oledb connection string
https://www.connectionstrings.com/mysql/

 

[NeoneedsaPC]

I have all the Code except the Main MySQL done,and this is a voluntary work i will do for my School so the School Server will finally be used.They have a full Rack with 10Gbps but have nothing running,so i wanna help with a School PC Network.

 

[rgd1101]

"I never worked with MySQL Integration before." so what database have you integrated with before?

 

[NeoneedsaPC]

I have currently a Excel Table hosted on my Server and it downloads it and reads the Stuff.

 

[rgd1101]

excel is not a database, it a spreadsheet, read up on oledb for vb.net