fetch record from Database and display it into gridview

Posted by Bubaibanerjee under ASP.NET on 2/13/2013 | Points: 10 | Views : 1878 | Status : [Member] | Replies : 4
Details are coming in this way from Database
UserName ConfigItem ProjectTraining Documentation Troubleshooting CodeChange Total
Bhanu Goankar AFOTA 7 18 25
Bubai Banerjee AFOTA 7 16 23
Total AFOTA 14 34 48
Bhanu Goankar GENERAL 38 2 40
Bubai Banerjee GENERAL 36 3 39
Total GENERAL 74 5 79


But I want it in this in this below way

ConfigItem AFOTA AFOTA GENERAL GENERAL
UserName Documentation CodeChange ProjectTraining Troubleshooting Total
Bhanu Goankar 7 18 38 2 65
Bubai Banerjee 7 16 36 3 62
Total 14 34 74 5 127

I am using Asp.net 4.0 and Sqlserver 2008. I want to fetch record from Database to gridview.I am very new in this system(Freshers).I need it urgently.So please help me if anybody can.Thanks in Advance




Responses

Posted by: Kusumas on: 2/14/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

This is not understandable, give me the clear information what you need exactly.

Thanks

Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Salman on: 2/14/2013 [Member] Starter | Points: 25

Up
0
Down
Try an alternative to grid view are you just showing the data in gridview or performing some action

Salman Farooqui

Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Salman on: 2/14/2013 [Member] Starter | Points: 25

Up
0
Down
Use Formview instead of gridview

Salman Farooqui

Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Murugavelmsc on: 2/15/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

Instead of using select * from table_name
rewrite as "select UserName Documentation CodeChange ProjectTraining Troubleshooting Total from tablename"

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Bubaibanerjee, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response