Rotating a DataGrid

[Steve Heckler]

Hi, All,

I'm helping a client solve a tricky problem. Any suggestions on the below?
Your help is greatly appreciated.

I'm looking to build a dynamic datagrid. Dynamic by columns. In other
words, the row result of a query will be the column headers. For example, a
query result of inventory by location:

Location Qty On Hand
Atlanta 12
Dallas 52
Pittsburgh 4
Chicago 16

Would show up in the datagrid as follows:
- -------------------------------------------------------------------
-
- Atlanta - Dallas - Pittsburgh - Chicago -
- 12 - 52 - 4 -
-
- -------------------------------------------------------------------
-

Any ideas on how to do this? Links to relevant online or .NET Framework SDK
articles would be fine. Thanks!

 

[Craig]

You could use a datalist with the RepeatDirection property set to
Horizontal.
That worked for me.

 

[Alvin Bruney [MVP]]

Here is some code:
http://24.204.143.27/dotnet/flip.htm

 

[Steve Heckler]

Alvin,

Terrific -- a big thanks to you and Craig for your helpful replies.

Steve

Here is some code:
http://24.204.143.27/dotnet/flip.htm

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi, All,

I'm helping a client solve a tricky problem. Any suggestions on the
below?
Your help is greatly appreciated.

I'm looking to build a dynamic datagrid. Dynamic by columns. In other
words, the row result of a query will be the column headers. For example,
a
query result of inventory by location:

Location Qty On Hand
Atlanta 12
Dallas 52
Pittsburgh 4
Chicago 16

Would show up in the datagrid as follows:

- ------------------------------------------------------------------ -

-
- Atlanta - Dallas - Pittsburgh - Chicago -
- 12 - 52 - 4 -
-

- ------------------------------------------------------------------ -

-

Any ideas on how to do this? Links to relevant online or .NET Framework
SDK
articles would be fine. Thanks!

 

[Steve Heckler]

Alvin,

Thanks again for your help. Quick question for you: what code should
go in the [snip] regions that you marked? That's not clear to me. A
client of mine who just tried this code wrote me and said:

I ran it and it went from 3 columns and 4 rows to 2 columns and 3
rows, should have gone to 4 columns and 3 rows.......

Thoughts? I enormously appreciate your help.

Steve

Here is some code:
http://24.204.143.27/dotnet/flip.htm

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi, All,

I'm helping a client solve a tricky problem. Any suggestions on the
below?
Your help is greatly appreciated.

I'm looking to build a dynamic datagrid. Dynamic by columns. In other
words, the row result of a query will be the column headers. For example,
a
query result of inventory by location:

Location Qty On Hand
Atlanta 12
Dallas 52
Pittsburgh 4
Chicago 16

Would show up in the datagrid as follows:
- -------------------------------------------------------------------
-
- Atlanta - Dallas - Pittsburgh - Chicago -
- 12 - 52 - 4 -
-
- -------------------------------------------------------------------
-

Any ideas on how to do this? Links to relevant online or .NET Framework
SDK
articles would be fine. Thanks!

 

[Alvin Bruney [MVP]]

[snip] code should be the number of times you repeat the two previous lines
to get sufficient columns.

Your client is missing an additional column, or the bounds on the for loop
are incorrect which is why he is coming up short.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Alvin,

Thanks again for your help. Quick question for you: what code should
go in the [snip] regions that you marked? That's not clear to me. A
client of mine who just tried this code wrote me and said:

I ran it and it went from 3 columns and 4 rows to 2 columns and 3
rows, should have gone to 4 columns and 3 rows.......

Thoughts? I enormously appreciate your help.

Steve

Here is some code:
http://24.204.143.27/dotnet/flip.htm

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi, All,

I'm helping a client solve a tricky problem. Any suggestions on the
below?
Your help is greatly appreciated.

I'm looking to build a dynamic datagrid. Dynamic by columns. In
other
words, the row result of a query will be the column headers. For
example,
a
query result of inventory by location:

Location Qty On Hand
Atlanta 12
Dallas 52
Pittsburgh 4
Chicago 16

Would show up in the datagrid as follows:
- -------------------------------------------------------------------
-
- Atlanta - Dallas - Pittsburgh -
Chicago -
- 12 - 52 - 4 -
-
- -------------------------------------------------------------------
-

Any ideas on how to do this? Links to relevant online or .NET
Framework
SDK
articles would be fine. Thanks!