private void button1_Click(object sender, EventArgs e)
{
this.Hide();
var vizualizareInregPersonal = new MeniuAdministrator_AdaugarePersoanl(ContAdministrator);
vizualizareInregPersonal.ShowDialog();
this.Close();
}
private void btnStergerePersonal_Click_1(object sender, EventArgs e)
{
conn.Open();
OleDbCommand cmdSelect;
OleDbDataReader reader;
// cmdSelect = new OleDbCommand("SELECT idDC FROM DetaliiCont where DetaliiCont.User = @User", conn);
// cmdSelect.Parameters.AddWithValue("@User", this.txtUser.Text);
//reader = cmdSelect.ExecuteReader();
// reader.Read();
// idCont = reader.GetValue(0);
if (this.dataGridView1.SelectedRows.Count > 0)
{
dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
}
try
{
OleDbCommand cmd = new OleDbCommand("Delete from DetaliiCont where Cstr(idDC)='" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'", conn);
cmd.ExecuteNonQuery();
OleDbCommand cmd2 = new OleDbCommand("Delete from Conturi where Cstr(idCont)='" + dataGridView1.CurrentRow.Cells[7].Value + "'", conn);
cmd2.ExecuteNonQuery();
conn.Close();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
MeniuAdministrator_AdaugarePersoanl form = new MeniuAdministrator_AdaugarePersoanl(contAdministrator);
form.Refresh();
}
