programmatically setting DataGridView column widths

[=?Utf-8?B?bWljaGFlbCBzb3JlbnM=?=]

I am wondering what is considered a best practice for setting column widths
to fit the data for a DataGridView (.Net 2.0) that was created on-the-fly
from an arbitrary query. What I would probably do is scan the width of each
column for the first couple hundred or so rows and find the largest. (But how
does one convert character counts to field widths in pixels?)

More generally, however, is there a better approach to accomplish this?

[=?Utf-8?B?bWljaGFlbCBzb3JlbnM=?=]

Linda's suggestion solved my issue, in that upon loading a result set the
displayed columns adjusted to the data automatically.

I am curious about Andrus' point also, however. When I ran the sample code
it took about 30 seconds to resize the column after double-clicking the
column header separator, as he indicated. Note that this is a somewhat
different case--it allows the user to resize columns to the data on demand
rather than automatically.

[Andrus]

Michael,

I am curious about Andrus' point also, however. When I ran the sample code
it took about 30 seconds to resize the column after double-clicking the
column header separator, as he indicated. Note that this is a somewhat
different case--it allows the user to resize columns to the data on demand
rather than automatically.

Nicholas Paldino wrote in other thread, that immediate resize should occur
and requested code to reproduce.
I created this code to reproduce the issue.

This sample demonstates that for Virtual DataGridView containing large
number of rows, automatic column resize based on visible rows is not
possible.

Is this DataGridView bug ?

Andrus.

[Linda Liu[MSFT]]

Hi Michael,

Thank you for your reply!

(1) In the workaround I gave you in my previous reply, once a
DataGridViewColumn's width reaches a given maximum, this column's
AutoSizeMode property is set to None, which means this column will not
autosize with its cell content unless its AutoSizeMode property is set to
NotSet again.

I think in my situation this could be simplified because I only need to

size the

columns when I load the DataGridView with data, though this could happen
many times during a given run.

If the data source bound to the DataGridView remains the same and you only
load data into the data source many times, you do need to handle the
CellValueChanged event of the DataGridView in case that the actually
required column widths become shorter than the given maximum value in the
later data loading.

(2) The workaround I provided in my previous reply has already met this
requirement. Once a column autosizes up to a given maximum, its
AutoSizeMode property is set to None so that the user can grab the column
separator to resize the column manually as he/she likes.

Hope this helps.
If you have any question, please feel free to let me know.

Sincerely,
Linda Liu
Microsoft Online Community Support