C# database

Question

Hello everyone,

I have sql db with many tables but i want to be able to edit 2 tables and only 1 column in each together.

to make my self clear this is an example:

first table: location
                  xyz


second table: location of device
                        xyz, dev1

so im trying to create a simple winform that when i open it:
1. a column that shows the data in location table as it is in the db (cannot be edited)
2. a column called new location that i can change each location name.

and when i change the location name in the winform it has to effect also the location of device which means it has to effect the 2 columns.

im a newbie in C# so I would really appreciate any help

Thanks in advanced