private void listDesSalariesToolStripMenuItem_Click(object sender, EventArgs e)
{
Salarie s = new Salarie();
List_des_Salarie l = new List_des_Salarie();
l.MdiParent = this;
l.dataGridView1.Rows.Clear();
l.dataGridView1.DataSource = s.Act("salarie");
l.Show();
}
private void button2_Click(object sender, EventArgs e)
{
formulair2 f = new formulair2();
try
{
Program.cnx.Open();
Program.cmd.Connection = Program.cnx;
Program.cmd.CommandText = "select numCongé , Nom , Prenom , nomb from congé as c , salarie as s where c.matricule = s.matricule and numCongé=" + comboBox1.Text;
Program.dr = Program.cmd.ExecuteReader();
if (Program.dr.Read())
{
f.Show();
f.textBox1.Text = Program.dr[0].ToString();
f.textBox2.Text = Program.dr[1].ToString();
f.textBox3.Text = Program.dr[2].ToString();
f.textBox4.Text = Program.dr[3].ToString();
}
Program.dr.Close();
Program.cnx.Close();
Salarie S = new Salarie();
dataGridView2.DataSource = S.Act("Congé");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
