write EID in Datagridview cel fill automatically another cel

Question

my question is

in datagridview enter first cell of E_ID and in anoter cell of datagridview fill automatically that related E_ID data record.
means in rest of cells fetch data from different tables of database

i know that it is done by query but dont know how to write.