Posts Tagged ‘MySQL’
October 31 2008
No Comment
Resolving Query Problems Using Subquery
Sometimes when working with databases and records, we have find difficulties in displaying data from many tables using SQL especially using join syntax. For example you want to include some aggregate columns from three tables below :
the structure of the products table :
1
2
3
4
5
ProductID text(15),
VendorID text(15),
Descriptions text(50),
UnitsInStock integer,
Price integer
Data in [...]
October 22 2008
1 Comment
How to Connect the VB 2005 to MySQL
Here is how to connect Visual Basic.Net to the MySQL database:
1. In the project - add reference - on the tab. Net - find MySql.Data - click OK
2. In the namespace - imports mysql.data.mysqlclient
3. In the form load or in the module or whatever form
type this code to connect with mysql
1
2
3
4
5
6
Dim myString [...]