Delete from Database

// Step 6
// Cleanup DeptTab table data
OracleCommand cmd2 = new OracleCommand("",connection);

// Delete all the rows from the DeptTab table
cmd2.CommandText = "DELETE depttab WHERE deptno = :1";

// Bind with an array of 3 items
cmd2.ArrayBindCount = 3;

OracleParameter param1 = new OracleParameter();
param1.OracleDbType = OracleDbType.Int32;
param1.Value = myArrayDeptNo;
cmd2.Parameters.Add(param1);

// Execute the delete statement through command
try

{
	cmd2.ExecuteNonQuery();
	Console.WriteLine("Cleaned DeptTab table data");
}
catch (Exception e)
{
	Console.WriteLine("Cleanup Failed:{0}" ,e.Message);}
finally
{
	// Dispose the OracleCommand objects
	cmd1.Dispose();
	cmd2.Dispose();

	// Close and Dispose the OracleConnection object
	connection.Close();
	connection.Dispose();
}