1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e)
{
System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(oradb);
conn.Open();
string sql = "DELETE * FROM USAGER WHERE USERID = la colonne en question;";
System.Data.OracleClient.OracleTransaction trans = conn.BeginTransaction();
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(sql, conn);
cmd.CommandType = System.Data.CommandType.Text;
cmd.Transaction = trans;
try
{
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
}
finally
{
cmd.Dispose();
conn.Close();
}
DetailsView1.DataBind();
} |