ADO.net Updating Data

// Create the DataAdapter and DataSets
OracleCommand DbCmd = new OracleCommand (
   "SELECT rowid, deptid, deptname FROM department", DBConn);
 
myDataAdapter = new OracleDataAdapter();
myDataAdapter.SelectCommand = DBCmd;
myDataAdapter.Fill(myDataSet, "Departments");

// Build the Update rules
// Specify how to update data in the data set
myDataAdapter.UpdateCommand = new
OracleCommand(”UPDATE department SET deptname = ? “, deptid = ? ” +
“WHERE rowid =?”, DBConn);

// Bind parameters
myDataAdapter.UpdateCommand.Parameters.Add(
“param1″, OracleDbType.VarChar, 100, “deptname”);
myDataAdapter.UpdateCommand.Parameters.Add(
“param2″, OracleDbType.Number, 4, “deptid”;
myDataAdapter.UpdateCommand.Parameters.Add(
“param3″, OracleDbType.Number, 4, “rowid”);