DataGridView Calculations
-
hi everybody i m doing a small banking application i have three tables master,transactions,ledgers if i m entering the opening balance from master table it inserts in the ledger table and display that value properly. if i update that value in master it updates ledger value properly. i enter the values in grid view and save them they are saved in ledger table as well as corresponding tables.here i m using storedprocedures for saving values. ledger table is read only it displays only report in gridview **transaction table have 3 columns ------------------------------------------- date | deposit | withdrawl ------------------------------------------- **my ledger table have 4 columns ------------------------------------------- date | deposit | withdrawl | balance ------------------------------------------- now the task is if i enter amount in 'deposit'column of 'transaction table's gridview' ,it displays in deposit column of ledger gridview for suppose i enter amount in 'withdrawl 'column of 'transaction table's gridview' ,it displays in withdrawl column of ledger gridview now balance will be calculated and displays in balance column of ledger's gridview how can i calculate and displays in gridview of ledger ------------------------------------------------------------------- date ------ deposit---- withdrawl-----balance ------------------------------------------------------------------- 1/1/2000----1500-----------0----------1500 2/2/2000------0----------1000----------500 3/3/2000-----700-----------0----------1200 4/4/2000------0-----------200---------1000 ------------------------------------------------------------------ like this i need hope u help me n this issue with regards, nagendra kumar
-
hi everybody i m doing a small banking application i have three tables master,transactions,ledgers if i m entering the opening balance from master table it inserts in the ledger table and display that value properly. if i update that value in master it updates ledger value properly. i enter the values in grid view and save them they are saved in ledger table as well as corresponding tables.here i m using storedprocedures for saving values. ledger table is read only it displays only report in gridview **transaction table have 3 columns ------------------------------------------- date | deposit | withdrawl ------------------------------------------- **my ledger table have 4 columns ------------------------------------------- date | deposit | withdrawl | balance ------------------------------------------- now the task is if i enter amount in 'deposit'column of 'transaction table's gridview' ,it displays in deposit column of ledger gridview for suppose i enter amount in 'withdrawl 'column of 'transaction table's gridview' ,it displays in withdrawl column of ledger gridview now balance will be calculated and displays in balance column of ledger's gridview how can i calculate and displays in gridview of ledger ------------------------------------------------------------------- date ------ deposit---- withdrawl-----balance ------------------------------------------------------------------- 1/1/2000----1500-----------0----------1500 2/2/2000------0----------1000----------500 3/3/2000-----700-----------0----------1200 4/4/2000------0-----------200---------1000 ------------------------------------------------------------------ like this i need hope u help me n this issue with regards, nagendra kumar
I don't see the problem, you write the transactions back to the database, presumably you have a proc to supply the ledger data so recall that proc after each transaction entry.
Never underestimate the power of human stupidity RAH