退出amont银行系统，请帮助 [英] withdrawing amont banking system please help

问题描述

你好.

我正在做一个简单的C#项目，我完全陷入了困境.

对于提款金额，我有一个表格，其中有用于输入帐户号，帐户持有人姓名，日期和提款金额的文本框.

我正在尝试以这样一种方式进行编码，即从Microsoft Access数据库中的用户余额中减去提取的金额，并且还更新了交易表.

请帮助我.

Hello.

I am working on a simple c# project and I am completely stuck at one point.

For withdrawing amount I have a form where I have text boxes for Account no, Account holder name, Date, amount withdraw.

I am trying to code in such a way that the amount withdrawn is subtracted from the user balance in the Microsoft Access database and the transaction table is also updated.

Please help me.

推荐答案

在不知道数据库确切架构的情况下很难精确，但应该就像编写一样简单一个INSERT SQL查询事务，以及一个INSERT或UPDATE查询余额，这取决于它在数据库中的结构.

顺便说一句，除非是经过计算的，否则数据库中的任何地方都不应真正存在平衡"列.

It is difficult to be precise without knowing the exact schema for your database but it should be as simple as writing an INSERT SQL Query for the Transaction and either an INSERT or an UPDATE Query for the Balance, depending on how it is structured in the database.

Incidentally, there should not really be a ''Balance'' column anywhere in the database unless it is a calculated one.

这篇关于退出amont银行系统，请帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！