error-'ExecuteNonqury' on type 'SqlCommand' not found

  • Thread starter Thread starter JenHu
  • Start date Start date
J

JenHu

Hi all,


I have an error message: "Public member 'ExecuteNonqury' on type
'SqlCommand' not found."
on objComd.ExecuteNonqury().

Can someone point me out where did I do wrong? Thanks.

The code is like this:
-----------------------------------
Dim strSQL As String
strSQL = "UPDATE Epay_Transaction_Table SET EAcct_Num =' " &
sEfundNum & "' and Error_Code='" & sErrorCode & "' where
EmployID='" & sEmpID & "' and Batch_Num=' " & BatchNum
& "'"
Dim objComd = New SqlCommand(strSQL, EpayConnection)
EpayConnection.Open()
objComd.ExecuteNonqury()
EpayConnection.Close()

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
 
I think it's ExecuteNonQuery, not ExecuteNonQuery.

If that doesn't help, put the method call in a TRY....CATCH block. If it
raises an exception, the message property of the exception object will
contain (usually) a very informative error message.

Good Luck
 
Back
Top