fetch record from Database and display it into gridview

Posted by Bubaibanerjee under ASP.NET on 2/13/2013 | Points: 10 | Views : 2753 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

Latest Posts