I'm New to SQL programming, but getting some results! I want to add data to a table that I created in the SQL Manager tool. The INSERT statement seems pretty self explanatory,
What do I need to do in my VB code before I put this in?
INSERT INTO tablename
(col1, col2, col3...)
VALUES (data1, data2, data3...)
I'm sure I need to open a connection to the DB with
or something along those lines. What else do I need? Any help would be appreciated.
dim conSQL as new SqlConnection(DBLocation)