Pivot result Display in Gridview(Asp.net)

Hi , I have a doubt and i am sending you the details below, what i want to display in Gridview. below i am describing the sql Table Structure.

 Original Table Structure.
 ID                Date             TimeLogged(Hrs)        UserName
 1             10/8/2012               5.50                          Bubai
 2             11/8/2012               2.30                          Bubai
 3             10/8/2012               3.30                          Bhanu
 4             11/8/2012               7.30                          Bhanu

I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table. i want to show details in Gridview(Front End).

Date                    Bubai               Bhanu                     Total
10/8/2012              5.30                   3                         8. 30
11/8/2012              2.30                  7.30                       10
Total                   8                    10.30                   18.30

Please help me to solve this issue. It’s really urgent. if you can reply early I’ll really appreciate. Thanks in advance.

Thanks and Regards Bubai Banerjee

asked Aug 23 '12 at 06:31 AM in Default

bubaibanerjee
0 ● 1 ● 1

Thanks for your question but this is a SQL Server forum so you may not get a very quick, or detailed, reply. Can you post what error you are getting or where you are stuck. It seems to me that the you will need some sort of tablix control like SSRS uses in cases like this but I am not an ASP.Net developer

Aug 23 '12 at 09:32 AM Fatherjack ♦♦

(comments are locked)