On the data tab where you input the sql query, your query should have a condition statement. Let's say you have name the dropdown list name as EmployeeID,
at your query, it will be as follow:
SELECT * FROM [TABLE_NAME] WHERE employee_id = @EmployeeID