Expand|Select|Wrap|Line Numbers
- objOleDbConnection.Open();
- OleDbDataReader objReader = objSelectAccount.ExecuteReader();
- while (objReader.Read())
- {
- cmbAccountTransfer.Items.Add(objReader["Account Number"]);
- }
- objOleDbConnection.Close();
Expand|Select|Wrap|Line Numbers
- private void TransferAccountInformation()
- {
- objSelectAccountData.Parameters["Account Number"].Value = cmbAccountTransfer.SelectedItem;
- objOleDbConnection.Open();
- OleDbDataReader objReader = objSelectAccountData.ExecuteReader();
- objReader.Read();
- m_decBalanceTransfer = Convert.ToDecimal(objReader["Balance Amount"]);
- objReader.Close();
- objOleDbConnection.Close();
- }
Expand|Select|Wrap|Line Numbers
- private void TransferAccountInformation()
- {
- objSelectAccountData.Parameters["Account Number"].Value = cmbAccountTransfer.SelectedItem;
- objOleDbConnection.Open();
- OleDbDataReader objReader = objSelectAccountData.ExecuteReader();
- objReader.Read();
- m_decBalanceTransfer = Convert.ToDecimal(objReader["Balance Amount"]);
- objReader.Close();
- objOleDbConnection.Close();
- }
case "Transfer":
txtPin.PasswordChar = '\0';
Transfer(Convert.ToDecimal(txtTransfer.Text));
txtTransfer.Clear();
m_strAction = "NoAction";
TransferAccountInformation();
break;
And finally code which is supposed to update the balance on both accounts:
Expand|Select|Wrap|Line Numbers
- private void UpdateBalance()
- {
- objUpdateBalance.Parameters["Balance Amount"].Value = m_decBalance;
- objUpdateBalance.Parameters["Balance Amount"].Value = m_decBalanceTransfer;
- objUpdateBalance.Parameters["Original_Account Number"].Value = cmbAccountNumbers.SelectedItem;
- objOleDbConnection.Open();
- objUpdateBalance.ExecuteNonQuery();
- objOleDbConnection.Close();
- }