I would like to create a form with one dropdown box, and two text boxes.
emp name: textbox
salary : text box
when the form loads, the drop down box should have all the employee numbers populated from database table emp.
And when the user selects any of the emp no from dropdown box, then remaining text boxes, empname, sal should be filled with their corresponding values from database.
And Then I want to change the salary or empname for a selected empno, and save it back to database with modified values.
Can someone tell me how I can do it ?