طلب كود

SqlConnection conn = new SqlConnection("ConnectionString");
SqlCommand cmd1 = new SqlCommand("Update Accounts Set Balance=Balance-@Amount Where ID=@FromAccount", conn);
SqlCommand cmd2 = new SqlCommand("Update Accounts Set Balance=Balance+@Amount Where ID=@ToAccount", conn);
cmd1.Parameters.AddWithValue("FromAccount",Convert.ToInt32( txtFromAccount.Text));
cmd1.Parameters.AddWithValue("Amount",Convert.ToInt32(txtAmount.Text));
cmd2.Parameters.AddWithValue("ToAccount",Convert.ToInt32(txtToAccount.Text));
cmd2.Parameters.AddWithValue("Amount",Convert.ToInt32( txtAmount.Text));
try
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
}
}
catch
{
//Error
}
finally
{
conn.Close();
}
}