Karthik Murugesan Karthik Murugesan - 4 months ago 89
ASP.NET (C#) Question

How to execute a update statement using Oracle ODP.Net in C#

I am using

to work with Oracle database in my ASP.Net application. There is no help documentation in MSDN for ODP.Net and Oracle's documentation really really bad :(. I am not able find answer to this simple question.

Is it not possible to execute a simple update statement without having to build a
object and updating the

How to execute a update statement using Oracle ODP.Net in C#?


I will need to check the exact syntax, but here is some quick code off the top of my head

using (OracleConnection con = new OracleConnection(...))
  OracleCommand cmd = con.CreateCommand();
  cmd.CommandType = CommandType.Text;
  cmd.CommandText = "update table set col1 = :param1, col2 = :param2 where key = :keyValue";
  cmd.Parameters.AddWithValue("param1", 1);
  cmd.Parameters.AddWithValue("param2", "Text data");
  cmd.Parameters.AddWithValue("keyValue", "1");

The above creates a command object sets the command up to execute an SQL Update statement, in this example I show one way to setup a parameterized query, you should always go with a parameterized query. Once the command is setup you just call ExecuteNonQuery to actually execute the command.