Loading

ADO.NET

sandy

in dept table have two columns deptid,deptname and in emp table have eid,ename,deptid but when i was inserting the record in front end it have deptname only based on deptname i am getting the deptid and insert the record into emp table

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi13y ago
hi,

your quesion is not too much clear....

correct me! from frend end you have dept name, emp name and you want to add record in emp Master.

so first of all get dept id from deptMaster table from dept name

select deptId from deptName = @deptName.

now insert record in empMaster.

hope this will help you.