I don't know how to go about this. I have web form with two dropdown lists. one named Recruiter and the other Account manager. I have two two SQL tables named Perm_Commision_Lookup & UserList. The Perm_Commision_Lookup table does not contain recruiter's email, so I decided to Inner Join it with UserList table which contain recruiter emails. The LookupValue column from the Perm_Commision_Lookup table is what's displayed to the end user and the pk_LookupID column is the one that's inserted into the database. What I want to achieve is this: When a user select let's say "John Doe" from the Recruiter dropdown list, I want to send out an email to John Doe and at the same time insert the selected value (pk_LookupID) into the database. I set the DataTextField="LookupValue" and ...
Go to the complete details ...