General discussion

Locked Datagrid can display in row format

By pabidi ·
iam using in datagrid i am able to display 4ColoumsFor EX( in DB i have 4 fields p,q,r,s)in datagrid it is displaying in this format

p q r s
p1 q1 r1 s1

but i want the output in format given below


can any body help me in this regard...



This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

I do not beleive that the data grid is capable of transposing your data the way you want. My suggestion is to make the pivot within your select, then display the data without headings. You'd need to write a VERY goofy JOIN to get the data laid out the way you want, then UNION those JOINed SELECTs to acheive the pivot.

Better yet, write your own component for this, it would be fairly easy to do so. You'll be sacrificing the functionality of DataGrid, but you'll be able to do what you are looking for.


Collapse -

by jaisonmit In reply to Datagrid can disp ...

u can retrive the data in this format by changning the select statement in SQL

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums