public frmCompResult2(DataAdapters da)
        {
            InitializeComponent();
            param       = new tblParameters();
            leden       = da.VulLedenLijst();
            resultaten  = da.VulCompResultRecords();
            dataAdaptor = da;

            _windowState = new PersistWindowState(this, @"Leden\CompResult");

            cboJaar.Items.Add(DateTime.Today.Year - 1);
            cboJaar.Items.Add(DateTime.Today.Year);
            cboSeizoen.Items.AddRange(tblCompResult.CompSeizoen);


            DateTime now_date        = DateTime.Now;
            DateTime july_1_thisYear = new DateTime(DateTime.Now.Year, 7, 1, 0, 0, 0);

            if (now_date < july_1_thisYear)
            {
                cboJaar.SelectedIndex    = 1;
                cboSeizoen.SelectedIndex = 0;
            }
            else
            {
                cboJaar.SelectedIndex    = 0;
                cboSeizoen.SelectedIndex = 1;
            }

            InitializeDataGridView(dgView);
            #region Create Columns
            DataGridViewTextBoxColumn dgvc0 = new DataGridViewTextBoxColumn();
            dgvc0.Name    = "LidNr";
            dgvc0.Width   = 180;
            dgvc0.Visible = false;

            DataGridViewTextBoxColumn dgvc1 = new DataGridViewTextBoxColumn();
            dgvc1.Name     = "Naam";
            dgvc1.Width    = 180;
            dgvc1.ReadOnly = true;
            dgvc1.SortMode = DataGridViewColumnSortMode.Automatic;

            DataGridViewTextBoxColumn dgvc2 = new DataGridViewTextBoxColumn();
            dgvc2.Name     = "Bondsnummer";
            dgvc2.Width    = 60;
            dgvc2.ReadOnly = true;
            dgvc2.SortMode = DataGridViewColumnSortMode.Automatic;

            DataGridViewComboBoxColumn dgvc3 = new DataGridViewComboBoxColumn();
            dgvc3.Name     = "Klasse";
            dgvc3.Width    = 120;
            dgvc3.ReadOnly = false;
            dgvc3.SortMode = DataGridViewColumnSortMode.Automatic;
            dgvc3.Items.AddRange(tblCompResult.CompKlasses);

            DataGridViewTextBoxColumn dgvc4 = new DataGridViewTextBoxColumn();
            dgvc4.Name     = "Percentage";
            dgvc4.Width    = 80;
            dgvc4.ReadOnly = false;
            dgvc4.SortMode = DataGridViewColumnSortMode.Automatic;

            dgView.Columns.AddRange(new DataGridViewColumn[] { dgvc0, dgvc1, dgvc2, dgvc3, dgvc4 });
            dgView.ReadOnly = false;

            dgView.Width = 460;
            #endregion
            CreateRows();
            FillColumns();
        }