if employee present or absence [modified]
-
hai all, daily i put attendance for employee.i want to display 'x' under date in grid view. x means present.if employee present in that date as 13-06-2008 means,i want to display 'x' under this date 13-06-2008. i have 2 table. emp_id and emp_name are field names for employee details table. emp_id and date are field names for attendance table. i use dash(-) for space in following example. for ex, in my employee details table values are emp_id-------emp_name --11----------balaji --12----------ramu ...etc in my attendance table values are emp_id-------date --11-------11-06-2008 --11-------13-06-2008 --11-------14-06-2008 ...etc here date as 11-06-2008,13-06-2008,14-06-2008 are present date for emp_id 11.but there is no date as 12-06-2008 in attendance table for emp_id 11.so that date is absent date for emp_id 11. in web form side, if i select employee name as balaji,fromdate as 10-06-2008 and todate as 13-06-2008 means, i want to display 'x' under present date for emp_id 11 of emp_name balaji in grid view as follow, emp_id----emp_name----10-06-2008----11-06-2008----12-06-2008----13-06-2008 --11------Balaji------------------------------------x---------------------------------------x here display starting date as 10-06-2008 in above grid,because i select from date as 10-06-2008. ending date is 13-06-2008,because i select todate as 13-06-2008. so how to display 'x' under that present date for emp_id 11.
modified on Thursday, August 14, 2008 1:10 PM
-
hai all, daily i put attendance for employee.i want to display 'x' under date in grid view. x means present.if employee present in that date as 13-06-2008 means,i want to display 'x' under this date 13-06-2008. i have 2 table. emp_id and emp_name are field names for employee details table. emp_id and date are field names for attendance table. i use dash(-) for space in following example. for ex, in my employee details table values are emp_id-------emp_name --11----------balaji --12----------ramu ...etc in my attendance table values are emp_id-------date --11-------11-06-2008 --11-------13-06-2008 --11-------14-06-2008 ...etc here date as 11-06-2008,13-06-2008,14-06-2008 are present date for emp_id 11.but there is no date as 12-06-2008 in attendance table for emp_id 11.so that date is absent date for emp_id 11. in web form side, if i select employee name as balaji,fromdate as 10-06-2008 and todate as 13-06-2008 means, i want to display 'x' under present date for emp_id 11 of emp_name balaji in grid view as follow, emp_id----emp_name----10-06-2008----11-06-2008----12-06-2008----13-06-2008 --11------Balaji------------------------------------x---------------------------------------x here display starting date as 10-06-2008 in above grid,because i select from date as 10-06-2008. ending date is 13-06-2008,because i select todate as 13-06-2008. so how to display 'x' under that present date for emp_id 11.
modified on Thursday, August 14, 2008 1:10 PM
Add a field to show the x and set the visible property by calling a code behind method that takes the data for the row and works out if they are present or not
Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.