how to update from 1 table to another

Question

hallo Vulpes

I have a table in sql called tb1
the contents is something like this:
crse   dist   wintime   winweight
cd      1400    67.6       60
cd      1600    71.2       58
sv      1400     69.0      59

in tbl2 in sql
crse    dist     partime    winweight
cd       1400    
cd       1600  
sv        1400

I WANT TO AUTOMATICALLY UPDATE TBL2 PARTIME,WINWEIGHT WITH WINTIME ,WINWEIGHT FROM TBL1 WHERE CRSE AND DIST ARE THE SAME.


 

Answer 1

My PC har to communicate with a kit. For instance, i have to write a random value of power consumption in the textbox, and send that value to the kit.

It is important for the kit to receive the values as a number, because the kit controls a "plastic made" flower, which will react dependent on the power value. So the only job i will do with C#, is to write the values in the textbox and send those values with pressing "send" button.

Answer 2

Please elaborate it more