Create VB.Net Connection With SQL Server (Part 1)

There are many ways to  Create VB.Net Connection With SQL Server , on this occasion we will discuss three-way connection to the SQL Server namely: 

1. Using ODBC
2. Using SQL CLIENT (Special SQL Server)
3. OLEDB

For easier us to learn a variety of vb.net with sql server connection is good that we make a first database in the SQL SERVER and table-table. 
Database Name  : WORKSHOP
Tables :
1. Customer

   Note : customer_id = primary
2. Service

    Note : service_id = primary
3. H_Transaction

    Note : number = primary
4. D_Transaction

  Note : id = primary (auto)

  to be continue.............