Combine 2 table data and fetch to Gridview dropdown list in ASP.net
Hi,I have 2 table. Below are the table name. I want to match the employeeId from the both table and fetch the data to Gridview and particular one field should be in dropdown list within Gridview.
Employee...... (EmpID, EmpName, EmpAdd)
EmployeeSalary.....(EmpID, JobTitle, Salary)
Result should be like below.
EmpID EmpName, JobTitle, Salary.... these 4 fields need to be shown in gridview. Here JobTitle should be in dropdown within gridview. How can i do this.