Skip to main content

Posts

Showing posts with the label Connecting to MySQL with VB.net

Using MySQL with Visual Basic .Net

Before you use this code, here are my assumptions: You have background on database management system You know how to create a database in mysql You know how to add tables to the database You are familiar with Visual Basic .Net Things needed/installed: MySQL Connector Microsoft Visual Basic Express 2008 (Since this is what I'm using right now. You can use Visual Basic Express 2005 or the full version included in the Microsoft Visual Studio Package) MySQL Editor (I'm using WAMP's phpMyAdmin) Things to do: Create a database in MySQL with at least 1 table. I'm using the following in this sample: Database Name : Contacts Table Name : ContactInformation Fields : Id (int, autoIncrement), Name (varchar(64)), ContactNumber (varchar(20)) Sample Contents: Id Name ContactNumber 1 John Doe (yyy) yyy-yyyy 2 Jane Doe ...