Wednesday, March 23, 2011

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




Introduction

I created this blog just want to learn and share about Visual Basic Net, because I myself was starting to migrate from Visual Basic 6.0 to Visual Basic Net, so if there is written or I am wrong please post corrections and instructions from the masters who have long known Visual Basic Net.

Blog ini saya buat sekedar ingin belajar dan berbagi tentang Visual Basic Net, sebab saya sendiri sedang mulai migrasi dari Visual Basic 6.0 ke Visual Basic Net, untuk itu apabila ada tulisan atau posting saya yang keliru mohon koreksi dan petunjuknya dari para master yang sudah lama mengenal Visual Basic Net.