How do you pass variables from within Visaul Basic to a SQL statement.
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

