[SQL2000] insert query

Code:

---

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"

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.

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

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:

Code:

---

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

---