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); } }