ADO.NET

Question

in dept table have two columns deptiddeptname and in emp table have eidenamedeptid 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

Jignesh Trivedi · Answer

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.