Click here to Skip to main content
15,891,253 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
my problem is like this i have currency table need to update the rate base on each another
-------------------------------
|currency | SGD | MYR | USD |
-------------------------------
|SGD | ### | 3.00 | 1.30|
-------------------------------
|MYR | 3.00 | ### | 4.20|
-------------------------------
|USD | 1.30 | 4.20 | ### |

if i update row 1 currency SGD TO MYR is 3.00 so at the same time program will auto update row 2 value MYR To SGD 3.00

any idea to solve my problem ?

What I have tried:

i have try use data grid view but cannot meet my case
Posted
Updated 25-Feb-16 21:45pm
v3

1 solution

Table as in a database table? Just do two updates, update the MYR column to 3 where the currency is SGD, and update the SGD column to 3 where the currency is MYR.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900