write EID in Datagridview cel fill automatically another cel

thank u for your reply ..
again i need your favor...
        where to write this and how to relate datagridview

because i am directly insert data in database through datagrid view and in that while entering employee id in first cell... that related EID data is fill automatically from another tables in another cell of datagridview. so user can easely fillup data in another table of database

if u again not understand my problem then ask me....



 Thank you.

Hi...
        Use inner join first table Id e_id  and anther table id r_Id understand but data type must be same 


Example ...
 Select e.name' e.address,r.mobile from 1tablename
e innerjoin 2tablename r  on e.e_Id = r.r_id 


Understand dear