+- BP Forums (https://bpforums.info)
+-- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=55)
+--- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=56)
+---- Forum: VB.NET (Visual Basic 2010/2008) (https://bpforums.info/forumdisplay.php?fid=8)
+----- Forum: Programming Help (https://bpforums.info/forumdisplay.php?fid=9)
+----- Thread: MySql Database Queries in VB.Net (/showthread.php?tid=584)
MySql Database Queries in VB.Net - Moldraxian - 07-25-2012
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?
Re: MySql Database Queries in VB.Net - brandonio21 - 07-25-2012
Yes! You can make as many queries as you want! Simply reopen the connection and change the commandText, and you're good to go!
Re: MySql Database Queries in VB.Net - Moldraxian - 07-26-2012
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"?
Re: MySql Database Queries in VB.Net - brandonio21 - 07-26-2012
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?
Re: MySql Database Queries in VB.Net - Moldraxian - 07-26-2012
I want to receive the Order Received data first and then the Customer File Number.
Re: MySql Database Queries in VB.Net - brandonio21 - 07-26-2012
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?
Re: MySql Database Queries in VB.Net - Moldraxian - 07-26-2012
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.