private void InsertGroupProject_Click_1(object sender, EventArgs e)
        {
            AssignProjectToGroup form = new AssignProjectToGroup(null, null, "add");

            form.Show();
            this.Close();
        }
        private void ProjectGroups_CellClick_1(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex == ProjectGroups.NewRowIndex || e.RowIndex < 0)
            {
                return;
            }

            if (e.ColumnIndex == ProjectGroups.Columns["GroupDeleteButton"].Index)
            {
                string       dialog       = string.Format("Remove Project '{0}'?", ProjectGroups.Rows[e.RowIndex].Cells[1].Value);
                DialogResult dialogResult = MessageBox.Show(dialog, "Remove Project", MessageBoxButtons.YesNo);
                if (dialogResult == DialogResult.Yes)
                {
                    SqlConnection connection = new SqlConnection(connString);
                    connection.Open();
                    string     query1 = string.Format("SELECT Id FROM Project WHERE Title = '{0}'", ProjectGroups.Rows[e.RowIndex].Cells[1].Value);
                    SqlCommand cmd    = new SqlCommand(query1, connection);
                    int        id     = (Int32)cmd.ExecuteScalar();
                    string     query  = string.Format("DELETE FROM GroupProject WHERE GroupId = '{0}' AND ProjectId = '{1}'", ProjectGroups.Rows[e.RowIndex].Cells[0].Value, id);
                    cmd.CommandText = query;
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("Project Removed!");
                    ProjectGroups.Rows.RemoveAt(e.RowIndex);
                    connection.Close();
                }
                else
                {
                    MessageBox.Show("Project not Removed!");
                }
            }
            else if (e.ColumnIndex == ProjectGroups.Columns["GroupEditButton"].Index)
            {
                string Groupid            = ProjectGroups.Rows[e.RowIndex].Cells[0].Value.ToString();
                string projectid          = ProjectGroups.Rows[e.RowIndex].Cells[1].Value.ToString();
                AssignProjectToGroup form = new AssignProjectToGroup(Groupid, projectid, "edit");
                form.Show();
                this.Close();
            }
        }