Wednesday, December 26, 2012

ADF : Display the Index for Record in the Table ?

ADF : Display the Index for Record in the Table ?

APPROACH:1





SELECT ROW_NUMBER() OVER(ORDER BY  Employees.FIRST_NAME)AS ROW_NUMBER , Employees.EMPLOYEE_ID,
       Employees.FIRST_NAME,
       Employees.LAST_NAME,
       Employees.EMAIL,
       Employees.PHONE_NUMBER,
       Employees.HIRE_DATE,
       Employees.JOB_ID,
       Employees.SALARY,
       Employees.COMMISSION_PCT,
       Employees.MANAGER_ID,
       Employees.DEPARTMENT_ID
FROM EMPLOYEES Employees

*****************************************************

APPROACH:2

 















Set Value Property for outputText as neelmani.index+1