dynamic updatecommand with ado.net
391003Mar 26 2003 — edited Mar 27 2003Hi all, I really need your help. I am trying to use ado.net in a windows form to update an oracle datasource from a dataset using an update command. Now when using The OleDbUpdateCommand, VS.NET can automatically generate a dynamic update statement like this:
"OleDbUpdateCommand1.CommandText = "UPDATE MAINTable SET PROVIDER_ID = ?, PROVIDER_LNAME = ?, PROVIDER_FNAME = ?....."
and when the dataset.update command is called it uses the updatecommand and replaces the ? marks with the dynamic entries from the webform.
My problem is, when I try to duplicate the same thing using ODP I keep getting the error 'ORA-00911:invalid Character' and the only thing that I can see causing this is the ?. Has anyone resolved a problem like this? If so, how? I really need the help.