Regarding DataGridView

[C# Programming]

Hi everyone, I'd be grateful if you can help me on this:
Suppose I have this table:

Code Name
---- ----
1 A
2 B
3 C

When bound to a DataGridView, when choosing from the Code column a value of say "2" how would I populate the corresponding value from column Name that is "B" in this case??

Thanks a million guys!

All generalizations are wrong, including this one!
(\ /)
(O.o)
(>&lt)