dropdownlist code-value pair mapping
I have two databases db1 and db2.
Database db1 has table tbl1 containing fields empcode1 and salary.
Database db2 has table tbl2 containing fields empcode2 and empname.
I am showing empname from the tbl2 of database db2 in the dropdownlist-ddl1.
On clicking submit button I want to display salary of all those employees whose empcode1 matches with empcode2 in the 2 tables of db1 and db2.
So the empname in tbl2 should get mapped into empcode2 internally in the code & then match with corresponding empcode1 in table tbl1
How to handle the dropdownlist ddl1 for empname,empcode1 & empcode2?
empcode, empcode1, empcode2 are of type varchar.
I need some guiding code.