Fetch record from Database and display it into gridview

Question

0.00/5 (No votes)

See more:

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). So please help me. Thanks in Advance

Posted 13-Feb-13 4:38am

bubai banerjee

Updated 13-Feb-13 5:25am

Karthik Harve

v3

Add a Solution

Comments

Richard C Bishop 13-Feb-13 10:40am

You will need to post the code you are using the achieve these results. Also, this is a repost. Doing that will only prolong your potential answer.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Karthik Harve* · Answer 1 · 2013-02-13T05:31:00

Hi,

check the below article.
Display Columns as Rows in GridView in ASP.NET[^]

in the article, author used, sample data for datatable, but you can modify as the result from your stored procedure or database query. Author also used "FlipFlopTable" function, there you have to modify according to the your display structure.

hope it helps.

Avik Ghosh22 · Answer 2 · 2013-02-13T07:25:00

Solution 3

http://www.aspdotnet-suresh.com/2013/01/convert-gridview-columns-to-rows-in.html[^][^]

Posted 13-Feb-13 7:25am

Avik Ghosh22