attendance
-
i am using .net 2005.i do my project in asp.net. My project title is master log attendance. our project is mainly used for see the employee attendance details. i want to put 'x' at date field in datagrid. here 'x' means present. date field will displayed as what we select from date and to date. i am using 2 tables.first table name as emp_details contain 2 field names as emp_id,emp_name. second table name as attendance contain 2 field names as emp_id,date. employees are put attendance daily. in web form i keep emp_name,from date,to date. i select emp_name,from date and todate. in following example i use dash(-) for space. for (ex): in emp_details table, values are emp_id---emp_name --11-------ashok --12-------ramu in attendance table, values are emp_id----date --11-----05-06-08 --11-----06-06-08 --11-----09-06-08 --12-----05-06-08 --12-----07-06-08 i select emp_name as ashok,from date as 05-06-2008,to date as 09-06-2008 means i want to display 'x' in date available in table for that selected name as ashok. emp_id--name----05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008 ---11----ashok------------x----------------x---------------------------------------------------x here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent. i select emp_name as all emp_name,from date as 05-06-2008,to date as 09-06-2008 means i want to display 'x' in date available in table for that particular name. emp_id--name---05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008 ---11---ashok------------x-----------------x---------------------------------------------------x ---12---ramu-------------x--------------------------------x here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent. like wise no 'x' for 06-06-2008,08-06-2008 and 09-06-2008 for ramu.because no date(06-06-2008,08-06-2008 and 09-06-2008) for id of ramu in attentance table.that means he is absent.
-
i am using .net 2005.i do my project in asp.net. My project title is master log attendance. our project is mainly used for see the employee attendance details. i want to put 'x' at date field in datagrid. here 'x' means present. date field will displayed as what we select from date and to date. i am using 2 tables.first table name as emp_details contain 2 field names as emp_id,emp_name. second table name as attendance contain 2 field names as emp_id,date. employees are put attendance daily. in web form i keep emp_name,from date,to date. i select emp_name,from date and todate. in following example i use dash(-) for space. for (ex): in emp_details table, values are emp_id---emp_name --11-------ashok --12-------ramu in attendance table, values are emp_id----date --11-----05-06-08 --11-----06-06-08 --11-----09-06-08 --12-----05-06-08 --12-----07-06-08 i select emp_name as ashok,from date as 05-06-2008,to date as 09-06-2008 means i want to display 'x' in date available in table for that selected name as ashok. emp_id--name----05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008 ---11----ashok------------x----------------x---------------------------------------------------x here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent. i select emp_name as all emp_name,from date as 05-06-2008,to date as 09-06-2008 means i want to display 'x' in date available in table for that particular name. emp_id--name---05-06-2008---06-06-2008 --07-06-2008 --08-06-2008 --09-06-2008 ---11---ashok------------x-----------------x---------------------------------------------------x ---12---ramu-------------x--------------------------------x here no 'x' for 07-06-2008 and 08-06-2008 for ashok.because no date(07-06-2008 and 08-06-2008 ) for id of ashok in attentance table.that means he is absent. like wise no 'x' for 06-06-2008,08-06-2008 and 09-06-2008 for ramu.because no date(06-06-2008,08-06-2008 and 09-06-2008) for id of ramu in attentance table.that means he is absent.
Seems pretty straight forward to me. What's your actual question?