Karthik Murugesan Karthik Murugesan - 3 months ago 66
ASP.NET (C#) Question

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

I am using

Oracle.DataAccess.Client
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
dataset
object and updating the
dataset
?

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

Answer

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(...))
{
  con.Open();
  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");
  cmd.ExecuteNonQuery();
}

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.