bind matrix query into any datatools like gridview,repeater etc

Question

0.00/5 (No votes)

See more:

how can i bind matrix data using any datatools like gridview,repeater etc.
My problem is,I have a sql-output like below(Using Query)

Monthid   month  head  amount
 6        june   DA    100
 6        june   TA    110
 6        june   HRA   330
 8        Aug    DA    210
 8        Aug    TA    620
 8        Aug    HRA   510
 1        jan    DA    250
 1        jan    TA    320
 1        jan    HRA   320

i want to display it in datacontrol like below

month  DA   TA   HRA

Jan    250  320  320
June   100  110  330
Aug    210  620  510

Posted 30-Jul-12 18:30pm

Nimisha Mary John

Updated 6-Aug-12 2:32am

v3

Add a Solution

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)

pradiprenushe · Answer 1 · 2012-07-30T19:06:00

Solution 1

try this actually i have not tested it but you will get logic.

SQL

select A.month ,
 (select B.amount where B.monthid=A.monthid and B.head='DA') as 'DA',
 (select B.amount where B.monthid=A.monthid and B.head='TA') as 'TA',
(select B.amount where B.monthid=A.monthid and B.head='HRA') as 'HRA'
from tablename A
inner join tablename  B on
A.monthid= b.monthid

Posted 30-Jul-12 19:06pm

pradiprenushe

Comments

Nimisha Mary John 6-Aug-12 0:41am

Sorry friend,I dont want query,I need to bind the given 'firstform of output' in a datacontrol like 2nd format