General discussion

Locked

asp.net Datagrid can display in row format

By pabidi ·
hi!!
iam using asp.net 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

p
q
r
s

can any body help me in this regard...

thanks

abidi

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.

J.Ja

Collapse -

by jaisonmit In reply to asp.net Datagrid can disp ...

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

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

Related Discussions

Related Forums