I need to change require dataset how iit possible tell me need this issue

Question

1.00/5 (1 vote)

See more:

EX:I have a stored procedure like(select center,dept,sum(Amount) from table where distno=19);(note:I am selecting those columns from multiple tables using joins) wrote that single query for understanding.....

so when i bind it dynamically the gridview looks

centre dept amount

hyd IT 2500

hyd cse 2600

hyd ECE 2700

bangl IT 2200

bangl CSE 2300

bang ECE 2500 ----like so on......as i have some no of centers and dept(based on selected distrtict center and dept varies)

I want to bind gridview like

HTML

Center	        IT 	CSE 	ECE
--------------------------------------
Hyderabad	2500	2600	2700
Banglore	2700	2200	2300
--------------------------------------

...

How can i achieve this??(hope the question is understandable)

Posted 31-May-14 22:03pm

raju 6

Updated 1-Jun-14 18:52pm

Prasad Avunoori

v2

Add a Solution

Comments

[no name] 1-Jun-14 4:20am

"hope the question is understandable", what question is it that you are referring to? There is no question or even a description of any kind of a problem in your posting anywhere.

agent_kruger 1-Jun-14 4:47am

sir, the irony of the question is it is not understandable.

Prasad Avunoori 2-Jun-14 0:53am

He wants to generate a pivot report.

Prasad Avunoori 2-Jun-14 0:54am

Hi Raju,

Have a look at my solution below.

1 solution

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)

Prasad Avunoori · Answer 1 · 2014-06-01T18:54:00

Solution 1

Pivoting DataTable Simplified[^]

Posted 1-Jun-14 18:54pm

Prasad Avunoori