private void lnkAdd_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            // Open form Customers
            frmCustomers frm = new frmCustomers();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                PopulateGrid();
            }
        }
        private void dgvCustomer_DoubleClick(object sender, EventArgs e)
        {
            // If no row is selected, return
            if (dgvCustomer.CurrentCell == null)
            {
                return;
            }
            // Store the PK of the selected row
            long pkid = long.Parse(dgvCustomer[0, dgvCustomer.CurrentCell.RowIndex].Value.ToString());
            // Open the Customers form
            frmCustomers frm = new frmCustomers(pkid);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                PopulateGrid();
            }
        }