SQL server 2005 problem

[mastiandchill]

Hey guys was up

can any one help me

when i try to run the follwing SQL command in VB.net

  Dim objCmdins As New SqlCommand("Insert into pay(payment_mode) values(" & temp & "')'", objConn)
  objCmdins.CommandType = CommandType.Text
  objCmdins.ExecuteNonQuery()

i get the error

The name "ATM" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

where pay is a table in SQL server 2005
Payment_mode is column of type ntext
temp is string with value ATM

[ryachza]

You appear to be missing the opening single quote before " & temp, so ATM rather than 'ATM' appears in your VALUES list.

[mastiandchill]

THX ryachza issue resolved