Post
Ask Question
ok ok

ok ok

  • NA
  • 34
  • 3.9k

Single Line view from many columns data ASP.NET GRIDVIEW

Oct 14 2016 4:31 AM

Hi,

My table look like this ,

creation_date event_name person_num full_name
7/21/2016 18:00:00:00 PM CLOCK_IN 40014 OSU
7/21/2016 19:00:00:00 PM CLOCK_OUT 40014 OSU
7/21/2016 20:00:00:00 PM CLOCK_IN 40014 OSU
7/21/2016 21:00:00:00 PM CLOCK_OUT 40014 OSU
7/21/2016 21:10:00:00 PM CLOCK_IN 40014 OSU
7/21/2016 21:30:00:00 PM CLOCK_OUT 40014 OSU














How to display in gridview like this

creation_Date person_num full_name CLOCK_IN1 CLOCK_OUT1 CLOCK_IN2 CLOCK_OUT2 CLOCK_IN3 CLOCK_OUT3 HoursWorked
7/21/2016 40014 OSU 18:00 19:00 20:00 21:00 21:10 21:30 2.2

Answers (2)