Posted on: 6/16/2013 5:15:09 PM | Views : 394

Hi, I have a table Events which has fields EventName and EventDateTime. I want to display daily time event on a listview or gridview or anything that looks like this:
DATE:                  TIME:
June 17, 2013       8:00-9:00 AM
                           1:00-4:00 PM
June 18, 2013       9:00-11:00 AM
                           3:00-6:00 PM
I have tried the SQL below. Im using ASP.net with c#. Any help would be appreciated. Thanks in advance.
SELECT EventDateTime, EventName FROM Events GROUP BY EventDateTime, EventName

...

Go to the complete details ...