how to put 'x' in date field in gridview
-
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 vb.net or C# code for,how to put 'x' at date field in gridview. 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 in gridview as follow. 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 in grid view as follow 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 want vb.net or C# code for to put x in date field in grid view. so how to put 'x' in date field in grid view.if employee present.
-
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 vb.net or C# code for,how to put 'x' at date field in gridview. 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 in gridview as follow. 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 in grid view as follow 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 want vb.net or C# code for to put x in date field in grid view. so how to put 'x' in date field in grid view.if employee present.
Are you using any GridView inbuild features Like Paging,Sorting... etc ? If no then you should not user Griview for this purpose Repeater control is best for displaying the data. There you can have your won type of colouns and you can show the things as you want. For example in these scenario create a user control which will common for each row This user control will be your item template You can show as you want. Else create a Custom Control here you will get more power as you will be resposible for rensering all HTML content in the Page
Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... " Check My Blog
-
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 vb.net or C# code for,how to put 'x' at date field in gridview. 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 in gridview as follow. 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 in grid view as follow 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 want vb.net or C# code for to put x in date field in grid view. so how to put 'x' in date field in grid view.if employee present.