is the order of parameters addition to a command for update command realy required?
-
i am using an oledbcommand object to perform both insert and update based on the command text supplied and i am adding the parameters for update also in the order of insert. So incase of update though, its not giving any error/exception but database is not getting updated. Can any body pls tell me how to resolve this or any other way to implement both the functionalities using single method. Thanks in advance.
-
i am using an oledbcommand object to perform both insert and update based on the command text supplied and i am adding the parameters for update also in the order of insert. So incase of update though, its not giving any error/exception but database is not getting updated. Can any body pls tell me how to resolve this or any other way to implement both the functionalities using single method. Thanks in advance.
The order of parameters should not be an issue. You need to first check your update stored procedures or statements. The easiest way to do this is to trying and execute them (using EXEC) directly in the database. This will enable you confirm whether they are OK.