Datagridview column limit

Question

I have a datagridview table that I need to display some data in. In certain instances, I exceed the column number limit and get the following error:

Sum of the columns' FillWeight values cannot exceed 65535

Is there any other tool that I could use to overcome this constraint?

Answer 1

Open a grid event columnAdded.

private void dataGridViewName_ColumnAdded(object sender, DataGridViewColumnEventArgs e)
{
    e.Column.FillWeight = 10;    // <<this line will help you
}

Answer 2

The default fill weight for a column in the DataGridView is 100. This combined with the maximun combined fill weight for the grid of 65535 means that with AutoGenerateColumns set to true you cannot have more than 655 columns in your data source.

If you need more columns than this then the only solution is to set AutoGenerateColumns for the grid to false, and then manually add the columns with a different fill weight (I'm not sure if 0 is a valid fill weight, so you may need to use 1).

---

It might be worth your while considering a different design - having so many columns in a DataGridView won't be very usable, the performance of the DataGridView is only tuned for up to 100 columns (I got that figure from this forum post by the DataGridView program manager)