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
