Is it possible to setup a DataGrid (SWF) to resize to the optimal size?

Question

Where "optimal size" is "all rows and columns are visible, but not more". (e.g. no dark gray background is visible)

Edit:
To clarify: I dont want to auto resize the columns. I have fixed width columns and rows. I want to have the whole control resized. e.g. reduce the width if there is dark gray space visible, increase the width if not all columns are visible, same for vertical space.

Answer 1

You'd think that every grid API would have an optimal size setting but it usually doesn't. i've used a number of different grids that did not support such a feature. But, calculating the optimal size yourself isn't that tough. There's even code out there.

Check out this Code Project link.

Answer 2

I don't think there exists such a command out of the box. So you have to do it on your own.

In this answer i already gave some hints about possible candidates you should consider by calculating the optimal size.

Answer 3

If you have fixed width columns then you should know how wide the grid is based on the number of columns returned by your query

grid.width = grid.columns[0].width + grid.columns[1].width etc.

That just leaves the height of the grid which would be something like

grid.height = grid.rowHeight * numberOfRowsFromQuery + grid.headerRowHeight

of course you might want to put some sort of maximum height limit on that. All air-coded so property names will need checking.