Visual Basic and MySQL
One of the best Database Server today besides from Oracle and Microsoft SQL Server is MySQL. MySQL is free and open source database server licensed under GNU General Public License.
Since the purpose of this article is to teach you on how to create a program using Visual Basic .NET and MySQL I will not discuss this topic in detail. Instead you will learn programming with this language and its database as quick as possible.
Required Software
- MySQL Database Server 5.0 or later
- MySQL Connector/NET 5.0 or later
- Toad for MySQL Freeware 3.0.0
- Microsoft Visual Basic 2008
I will create a similar tutorial on Database Programming Made Easy but this time using MySQL as our database management system.
- DataGridView Control with MySQL
- TreeView Control with MySQL
- ComboBox Control with MySQL
- CheckBox Control with MySQL
- How to Add-Update-Delete Record Using MySQL
If you want to experiment it yourself you should add a reference from the MySQL Connector/NET. This can be done by clicking the Project menu then Add Reference. After this browse the file at C:\Program Files\MySQL\MySQL Connector Net 5.0.x\Binaries\.NET 2.0. Where x is the version number of MySQL Connector/NET.
From time to time I will add new tutorials on this articles. If you want to be updated on this article kindly register and subscribe to this page.
Comments
XML literal cannot appear here unless it is enclosed.
XML literal cannot appear here unless it is enclosed in parentheses.
Do Until
ds.Tables("security").Rows(RowIX).Item("username") = txtuser.Text And _
ds.Tables("security").Rows(RowIX).Item("password").ToString = txtPass.Text
Me.Hide()
About.Show()
RowIX += 1
Loop
this is the code where in that error shown the that has" Do Until"
i can't the right answer, i'm just exploring the forums about this ...
can you please help me solved this error ... by the way i'm using vb.net 2008 and mysql server for this ...
thanks and godbless^^,
sir
can u send me a sample code of enrolment system using vb.net 6.0 and using the my sql ...send that to my email...karen_nueve@rocketmail.com...tnx i will really appreciate it...
problem push save button
when I press Save button, a message appeared :
Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
Help :(
Sir, please help me on how to connect vb6.0 to mysqlYOG..im a newbie..
tnx.. can u send me a sample codes..panibioaljohn@yahoo.com..
Pages
Add new comment