Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2008-02-25 : 08:31:13
|
| Hello All,How to bind the gridview with cross tab query?with following structure M1 M2----------------------------------------------------------------------------------------- A B A B--------------------------------------------------------------------------------------- P1 P2 ------------------------------------------------------------------------------------------Totalwhere M1 and M2 are column name and A and B are subcolumns for evry columns like M1 and M2 and and P1 and P2 are rows ?1)Is above scenario is possible with nested grid or repeater? How?2)Again I have to bind the grid on selected index change of treeview where evrery node of tree shows th P1 and P2? |
|
|
mahesh_bote
Constraint Violating Yak Guru
298 Posts |
Posted - 2008-02-27 : 03:54:31
|
| As far as I know, you can not directly bind your resultset to such controls. Its something like merging the columns. Try to find out is there any property like MERGE supported by any of the controls.Thanks,Mahesh |
 |
|
|
|
|
|
Cross tab query for gridview