How to pass primary key ID field as parameter/UPDATE Statement

Bootzilla33

I want to pass the ACTIVITY_ID field (which is primary key) on an update statement where clause . I need help on how to do that. Here is Update Statement and parameters:

conn.ConnectionString = strConnection;
conn.Open();

        OracleCommand cmd = new OracleCommand();
        cmd.Connection = conn;
        cmd.CommandText = "UPDATE BUYING\_ACTIVITY SET CUSTOMER\_SOURCE\_CODE = :custsrc, CUSTOMER\_NAME =:name, CUSTOMER\_CITY = :city, CUSTOMER\_STATE = :state WHERE \_ACTIVITY\_ID = ?";
              
        cmd.Parameters.Add(new OracleParameter(?));
        cmd.Parameters.Add(new OracleParameter("custsrc", custsrc));
        cmd.Parameters.Add(new OracleParameter("name", name));
        cmd.Parameters.Add(new OracleParameter("city", city));
        cmd.Parameters.Add(new OracleParameter("state", state));
        

        cmd.ExecuteNonQuery();

        conn.Close();

What value do I use to set = to ACTIVITY_ID on the WHERE clause is what I'm asking.

Lost User

That is a Database question, nothing to do with ASP.NET.

Richard Deeming

You pass the value in the same way as the other parameters:

cmd.CommandText = "UPDATE BUYING_ACTIVITY SET CUSTOMER_SOURCE_CODE = :custsrc, CUSTOMER_NAME =:name, CUSTOMER_CITY = :city, CUSTOMER_STATE = :state WHERE _ACTIVITY_ID = :activity_id";

cmd.Parameters.Add(new OracleParameter("activity_id", activity_id));
cmd.Parameters.Add(new OracleParameter("custsrc", custsrc));
cmd.Parameters.Add(new OracleParameter("name", name));
cmd.Parameters.Add(new OracleParameter("city", city));
cmd.Parameters.Add(new OracleParameter("state", state));

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer