MDIChild中的OutOfMemoryException

Question

我在MDIChild表单中有一个datagridview，我将在表单加载时通过调用以下函数对其进行自定义，

private void FillDetails()
    {
        dgvDefCofig.DataSource = dbLayer.tblDefConfigSelectAll().Tables[0];
        var columnheaderstyle = new DataGridViewCellStyle();
        columnheaderstyle.Font = new Font("Arial", 9, FontStyle.Regular);
        dgvDefCofig.ColumnHeadersDefaultCellStyle = columnheaderstyle;
        dgvDefCofig.Columns[dgvDefCofig.Columns.Count - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
        SetLineColumnDetails("ID", "", 0, DataGridViewContentAlignment.MiddleLeft, false);
        SetLineColumnDetails("DC_NoOfSmallBoxes", "No of Boxes", 50, DataGridViewContentAlignment.MiddleLeft, true);
        SetLineColumnDetails("DC_LabelPath", "Label path", 250, DataGridViewContentAlignment.MiddleLeft, true);
        SetLineColumnDetails("DC_Active", "Active", 100, DataGridViewContentAlignment.MiddleRight, true);
        SetLineColumnDetails("DC_InsertedDateTime", "Inserted Date", 100, DataGridViewContentAlignment.MiddleRight, true);
        SetLineColumnDetails("DC_ProdDate", "Producation Date", 100, DataGridViewContentAlignment.MiddleRight, true);
        SetLineColumnDetails("DC_ProdShift", "Shift", 0, DataGridViewContentAlignment.MiddleRight, false);
        SetLineColumnDetails("DC_CreatedBy", "Created By", 0, DataGridViewContentAlignment.MiddleRight, false);
        SetLineColumnDetails("DC_LastUpdateDate", "Last Updated", 0, DataGridViewContentAlignment.MiddleRight, false);
        SetLineColumnDetails("DC_LastUpdatedBy", "Lase Updated By", 100, DataGridViewContentAlignment.MiddleRight, true);
    }

    public void SetLineColumnDetails(string columnName, string headertext, int width,
                                     DataGridViewContentAlignment alignment, bool visible)
    {
        dgvDefCofig.Columns[columnName].Visible = visible;
        dgvDefCofig.Columns[columnName].HeaderText = headertext;
        dgvDefCofig.Columns[columnName].Width = width;
        dgvDefCofig.Columns[columnName].DefaultCellStyle.Alignment = alignment;
    }

但是，我收到了“OutOfMemoryException”。当我移除上面的方法时，应用程序运行良好。为什么会发生这种情况？

Answer 1

最有可能发生的情况是

dgvDefCofig.DataSource = dbLayer.tblDefConfigSelectAll().Tables[0];

将如此多的数据推送到DataGrid，这会使您的应用程序爆炸。

限制您在屏幕上加载的数据量，使用更多的“切片”SQL查询。