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"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)




Reply With Quote