[SQL2000] insert query

[TINEIZVO]

myCommand = New SqlCommand("INSERT INTO accounts 
(LAST_NAME, FIRST_NAME, ADDRESS, TELEPHONE, FAX, COUNTRY, E_MAIL) 
VALUES (dataset.LAST_NAME, dataset.FIRST_NAME, dataset.ADDRESS, 
dataset.TELEPHONE, dataset.FAX, dataset.COUNTRY, dataset.E_MAIL)", 
myConnection)

thats my query how do i solve an error "the name 'LAST_NAME' is not permitted in this context. only constants, exprations and vriables are allowed. coumn names are not allowed"

[shakti5385]

First thing I want to say you that do not use UnderScope in the field of the table.
Use FIRST_NAME AS FirstName same fro the LastName.

And for the problem check your dataset.

[TINEIZVO]

code or sql suggestions would be more welcome which include detailed explanations

[si_the_geek]

It looks like the problem is dataset - I presume this is an object in your code, rather than a table in your database.

You cannot use variables/objects inside (SQL) strings, you need to append the values to the string instead.

I don't use VB.Net, but I assume that what you need is something like this:

.. VALUES ('" & dataset.LAST_NAME & "', '" & dataset.FIRST_NAME & "', ..