How do you pass variables from within Visaul Basic to a SQL statement.

For Example
Dim cust_id AS Integer = 1
Dim cust_name AS String = "Customer Name"
Dim date_of_birth AS Date = ""

INSERT INTO customer (id, name) VALUES ('cust_id', 'Customer Name', 'date_of_birth')

I recall in Java, one would use the '+' operator to join strings as below.

INSERT INTO customer (id, name) VALUES ("+cust_id+",'" +Customer Name+"', '"+date_of_birth+"')"

and in ASP
INSERT INTO customer (id, name) VALUES ("&cust_id&",'" &Customer Name&"', '"&date_of_birth&"')"

How is this done in Visual Basic.
Thanks for your help

[714 byte] By [Dicy] at [2008-1-21]