public void populate()
        {
            CriminalDataBase criminalDB = new CriminalDataBase();

            list_criminals = criminalDB.Select_All();
            criminalsGridView.DataSource = list_criminals;
        }
        private void deleteBtn_Click(object sender, EventArgs e)
        {
            c            = new Criminals();
            c.criminalID = Convert.ToInt32(criminalsGridView.CurrentRow.Cells[0].Value.ToString());
            CriminalDataBase criminalDB = new CriminalDataBase();

            criminalDB.delete(c);
            populate();
        }
        private void saveBtn_Click(object sender, EventArgs e)
        {
            CriminalDataBase criminalDB = new CriminalDataBase();

            c                 = new Criminals();
            c.name            = nameTxt.Text;
            c.Age             = Convert.ToInt32(ageTxt.Text);
            c.criminalAddress = addressTxt.Text;
            c.dateOfArrest    = arrestTxt.Text;
            c.batchID         = Convert.ToInt32(batchIDTxt.Text);
            c.crimeID         = Convert.ToInt32(crimesTxt.Text);
            c.caseNo          = Convert.ToInt32(caseNoTxt.Text);
            criminalDB.insert(c);
            populate();
        }
        private void updateBtn_Click(object sender, EventArgs e)
        {
            CriminalDataBase criminalDB = new CriminalDataBase();

            c                 = new Criminals();
            c.criminalID      = Convert.ToInt32(criminalsGridView.CurrentRow.Cells[0].Value.ToString());
            c.name            = nameTxt.Text;
            c.Age             = Convert.ToInt32(ageTxt.Text);
            c.criminalAddress = addressTxt.Text;
            c.dateOfArrest    = arrestTxt.Text;
            c.batchID         = Convert.ToInt32(batchIDTxt.Text);
            c.crimeID         = Convert.ToInt32(crimeIDTxt.Text);
            c.caseNo          = Convert.ToInt32(caseNoTxt.Text);
            criminalDB.update(c);
            populate();
        }