Custom DataView to DataGrid

[RobEmDee]

Our client has asked for a DataGrid to be populated with one table's worth of data in which the table rows would be displayed as columns in the DataGrid. (The reason for this is not as ridiculous as it seems....it would be helpful for analysis in the given situation) The tricky part that I am having trouble planning out is doing this in a way that enables me to use a DataTable from a DataSet so that I can maintain tablemappings back to the db table and use the CommandBuilder for ease of updating, inserting. I am prepared to go the distance to make this happen, so any advice would be appreciated. Thanks!

[hellomadhu]

hi

have a look at cubes in sql-server 2000.

(you will have to install olap services to work with cubes)

there u have some options to do things like this. but i dont

know how far it fits ur requirement.

rgds
madhu