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.

asmita patil · Answer

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.

Zaid Ansari · Answer

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.addressr.mobile from 1tablename e innerjoin 2tablename r on e.e_Id = r.r_id Understand dear