MyLearningKit.Com

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 [...]

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 [...]