public void DeleteClientFinance(int accountID)
        
{
            SqlCommand cmd 
= null;
            SqlConnection conn 
= null;
            SqlTransaction trans 
= null;

            conn 
= new SqlConnection(connString);
            conn.Open();
            trans 
= conn.BeginTransaction();

            cmd 
= new SqlCommand(cmdDeleteBankAccount, conn);
            cmd.CommandType 
= CommandType.Text;
            cmd.Transaction 
= trans;

            SqlParameter parameter 
= new SqlParameter("@AccountID", SqlDbType.Int);
            parameter.Value 
= accountID;
            cmd.Parameters.Add(parameter);

            
try
            
{
                cmd.ExecuteNonQuery();
                trans.Commit();
            }

            
catch (SqlException ex)
            
{
                trans.Rollback();
                
throw ex;
            }

            
finally
            
{
                conn.Close();
                cmd 
= null;
                conn 
= null;
            }

            
        }
posted on 2007-02-02 11:19  Caviare  阅读(297)  评论(0编辑  收藏  举报