private void btnAdd_Click(object sender, EventArgs e)
        {
            frmAddEditVenue frm = new frmAddEditVenue();

            DatabaseConnection.adding   = true;
            DatabaseConnection.updating = false;
            if (frm.ShowDialog() == DialogResult.OK)
            {
                LoadData();
            }
        }
 private void btnEdit_Click(object sender, EventArgs e)
 {
     if (lvwVenue.SelectedItems.Count == 1)
     {
         frmAddEditVenue frm = new frmAddEditVenue();
         DatabaseConnection.adding   = false;
         DatabaseConnection.updating = true;
         frm.txtId.Text = lvwVenue.SelectedItems[0].SubItems[0].Text;
         if (frm.ShowDialog() == DialogResult.OK)
         {
             LoadData();
         }
     }
 }