Convert Update From Access To Sql And Have An Error.

I am trying to convert code I have working for access to work with SQL.


fldName, fldEmail, ID are the names in the database. recNum does have the value of the record that I want to edit. Here is the error I am getting.


System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '?'.


And here is the stack trace (which I don’t know how to read except for the line the error is on)


[SqlException: Line 1: Incorrect syntax near '?'.]


System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723


System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +194


goodellweb.adm_contact.editNow_Click(Object sender, EventArgs e) in C:Inetpubwwwrootwebrootgoodellwebadmadm_contacts.aspx.vb:306


System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108


System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57


System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18


System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33


System.Web.UI.Page.ProcessRequestMain() +1315


here is my code.





Dim editSQL As String = "Update tbEmail Set fldName=?, fldEmail=? Where ID=?"


Dim SqlConn As New SqlConnection(ConnStr)


Dim Cmd As New SqlCommand(editSQL, SqlConn)


Cmd.Parameters.Add(New SqlParameter("@fldName", nameEdit.Text))


Cmd.Parameters.Add(New SqlParameter("@fldEmail", emailEdit.Text))


Cmd.Parameters.Add(New SqlParameter("@recNum", recNum))





SqlConn.Open()


Try


Cmd.ExecuteNonQuery()


Finally


SqlConn.Close()


End Try


Response.Write("recNum " & recNum & " <br>")


Thanks


Michael