MySql Database Queries in VB.Net

[Moldraxian]

Hello! I followed Brandonio's videos on how to create a MySql Database and I have a question. Is it possible to make multiple queries so that a user could sort through the data from the database?

[brandonio21]

Yes! You can make as many queries as you want! Simply reopen the connection and change the commandText, and you're good to go!

[Moldraxian]

Thank you! That saved me quite a bit of research! Erm.. Were exactly do you do that?

I also have an issue with the login. I want to switch the login so it recognizes the first two fields of my database "Order Received" and "Customer File Number".

[code]Dim orderreceived As Boolean = True.

I have a feeling that this statement above is stopping the program from running. Is there anyway to make a login accept a field such as "Order Received"?

[brandonio21]

You are going to want to do that as soon as your first MySQL Query is called!

As for your next problem, do you want to make it so you are looking up a customer file number and getting if the order was received from the MySQL database?

[Moldraxian]

I want to receive the Order Received data first and then the Customer File Number.

[brandonio21]

I apologize, but I just don't know exactly what you are asking.. Could you explain exactly what you want to happen in your program?

[Moldraxian]

I have 38 fields in a MySql database that I wan't to display. But I am converting the program over to this 38 field database. The problem is, the line of code I linked above is stopping the program from running because I have no idea on how to make it Dim a two word expression or variable. Order Received is the first field and I need that line of code to be able to handle the name of the field.