Problem Inserting Data Into SQL Server 2000

Tryinna insert a new row





This is my code:


Dim myConn As SqlConnection


Dim mycmd As SqlCommand


myConn = New SqlConnection("Initial Catalog=science;" & _


"Data Source=localhost;Integrated Security=SSPI;")


mycmd = New SqlCommand("INSERT into STEP1(firstname) VALUES('Amin')", myConn)


myConn.Open()


mycmd.ExecuteNonQuery()


myConn.Close()





This is the error message I get:


The name 'firstname' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.