using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OracleClient;
public class MainClass
{
public static void Main()
{
OracleConnection oraConn = new OracleConnection();
string connString = "User Id=oranetuser; Password=demo; Data Source=oranet";
if (oraConn.State != ConnectionState.Open)
{
try
{
oraConn.ConnectionString = connString;
oraConn.Open();
MessageBox.Show(oraConn.ConnectionString, "Successful Connection");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"Exception Caught");
}
}
if (oraConn.State == ConnectionState.Open)
{
string sqlDelete = "delete from PlayerTable where player_num = :p_num";
OracleCommand cmdDelete = new OracleCommand();
cmdDelete.CommandText = sqlDelete;
cmdDelete.Connection = oraConn;
OracleParameter pPlayerNum = new OracleParameter();
pPlayerNum.DbType = DbType.Decimal;
pPlayerNum.Value = 1;
pPlayerNum.ParameterName = "p_num";
cmdDelete.Parameters.Add(pPlayerNum);
cmdDelete.ExecuteNonQuery();
cmdDelete.Dispose();
}
}
}
|