private void DisplayConnections_Load(object sender, System.EventArgs e)
        {
            BindConnectionGrid(ref ConnectionsdataGridView);

            BindHistoryGrid(ref HistorydataGridView);
            WinObjMethods.ResizeGrid(ref ConnectionsdataGridView);
            CorrectWindowSize();

            #region Test_grid


            //WMIMethods methods = new WMIMethods();
            //List<Connection> dt = methods.GetNetworkDevices();

            //AddColumn(ref ConnectionsdataGridView);


            //if (dt.Count > 0)
            //{
            //    var bindsList = new BindingList<Connection>(dt); // <-- BindingList
            //    //Bind BindingList directly to the DataGrid
            //    var source = new BindingSource(bindsList, null);
            //    ConnectionsdataGridView.DataSource = source;
            //}
            #endregion
        }
        private void DisplayConnections_Load(object sender, System.EventArgs e)
        {
            BindConnectionGrid(ref ConnectionsdataGridView);
            ConnectionsdataGridView.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
            ConnectionsdataGridView.AutoSizeRowsMode          = DataGridViewAutoSizeRowsMode.AllCells;
            BindHistoryGrid(ref HistorydataGridView);
            HistorydataGridView.DefaultCellStyle.WrapMode  = DataGridViewTriState.True;
            HistorydataGridView.AutoSizeRowsMode           = DataGridViewAutoSizeRowsMode.AllCells;
            HistorydataGridView.DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopLeft;
            WinObjMethods.ResizeGrid(ref ConnectionsdataGridView);
            CorrectWindowSize();
            HistorydataGridView.Rows[0].Selected = true;
            int widthScreen  = Screen.PrimaryScreen.WorkingArea.Width;
            int x            = widthScreen - this.ClientSize.Width;
            int heightScreen = Screen.PrimaryScreen.WorkingArea.Height;
            int y            = heightScreen - this.ClientSize.Height;

            this.Location = new Point((x / 2), (y / 2));
            #region Test_grid


            //WMIMethods methods = new WMIMethods();
            //List<Connection> dt = methods.GetNetworkDevices();

            //AddColumn(ref ConnectionsdataGridView);


            //if (dt.Count > 0)
            //{
            //    var bindsList = new BindingList<Connection>(dt); // <-- BindingList
            //    //Bind BindingList directly to the DataGrid
            //    var source = new BindingSource(bindsList, null);
            //    ConnectionsdataGridView.DataSource = source;
            //}

            #endregion
        }
        private void BindHistoryGrid(ref DataGridView dgv)
        {
            DbMethods         DB       = new DbMethods();
            List <Connection> connlist = DB.ReadConnectionHistory();

            AddColumn(ref dgv);

            foreach (Connection conn in connlist)
            {
                List <DNS>     dnslist = DB.ReadDNSHistory(conn.Id);
                List <Gateway> gtwlist = DB.ReadGatewayHistory(conn.Id);

                foreach (DNS dns in dnslist)
                {
                    conn.DNSServer = conn.DNSServer + dns.DNSServer + "; ";
                }
                conn.DNSServer = conn.DNSServer.Substring(0, conn.DNSServer.Length - 2);

                foreach (Gateway gtw in gtwlist)
                {
                    conn.IPGateway = conn.IPGateway + gtw.IPGateway + "; ";
                }
                conn.IPGateway = conn.IPGateway.Substring(0, conn.IPGateway.Length - 2);
            }

            if (connlist.Count > 0)
            {
                var bindsList = new BindingList <Connection>(connlist);
                //Bind BindingList directly to the DataGrid
                var source = new BindingSource(bindsList, null);
                dgv.DataSource = source;
            }

            WinObjMethods.ResizeGrid(ref dgv);
            CorrectWindowSize();
        }
        public void CorrectWindowSize()
        {
            int width = WinObjMethods.CountGridWidth(ConnectionsdataGridView);

            ClientSize = new Size(width, ClientSize.Height);
        }