Geek asks and answers

How to add a row of rows, columns and combine in Runtime on a GridView according to the data provided on Sqldatareader?

I am working on ASP.NET3.5. I have to point the Dataset to the GridView in the specified format at runtime.

Datset

EMP_ID EMP_NAME 2011-01-01_FLAG 2011-01-01_INDATE 2011-01-01_INTIME 2011-01-01_INSTATUS 2011-01-01_OUTDATE 2011-01-01_OUTTIME 2011-01-01_OUTSTATUS
1 Mr Netra Thapa ATTN 2011-01-03 09:01:59 EI 2011-01-03 18: 0: 15            
2 Mr Luja Manadhar ATTN 2011-01-03 10:15:00 LI 2011-01-03 17: 0: 15 EO  
3 Mr Kushal Joshi ABS NULL NULL NULL NULL NULL NULL
4 Mr Prakash Gobhaju ATTN 2011-01-03 09:00:15 NULL 2011-01-03 18:30:15 EO

I have to present this data using DataGird in the following format

Employee Id Employee Name 01-01-2011    
                                     In time out time remarks    
1 Mr Netra Thapa 09:01:59 18: 0: 15 Earlry In
2 Mr Luja Manadhar 10:15:00 17: 0: 15 Late In, Early Out
3 Mr Kushal Joshi Absent
4 Mr Prakash Gobhaju 09:00:15 18:30:15 Late Out

How is this possible?

+3

More articles:


All Articles