ADO.NET

Question

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

Answer 1

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.