public void fct()
{
//module.Items.Clear();
//professeur.Items.Clear();
//cin.Items.Clear();
//connection.Open();
//SqlDataReader myReader1 = null;
//SqlCommand myCommand1 = new SqlCommand("select * from Module ", connection);
//myReader1 = myCommand1.ExecuteReader();
//while (myReader1.Read())
//{
// //module.Items.Add(myReader1["Id_m"].ToString() + " - " + myReader1["Libelle"].ToString());
//}
//connection.Close();
//connection.Open();
//SqlDataReader myReader2 = null;
//SqlCommand myCommand2 = new SqlCommand("select * from Professeur", connection);
//myReader2 = myCommand2.ExecuteReader();
//while (myReader2.Read())
//{
// //professeur.Items.Add(myReader2["Id_prof"].ToString() + "- " + myReader2["Nom"].ToString());
// cin.Items.Add(myReader2["Id_prof"].ToString() + "- " + myReader2["Nom"].ToString());
//}
//connection.Close();
Telecharger.Hide();
}
private void button6_Click(object sender, EventArgs e)
{
Telecharger.Show();
cinText.Enabled = false;
String rechercher = this.rechercherText.Text;
connection.Open();
SqlCommand cmd = connection.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from Professeur" +
" WHERE cinprof ='" + rechercher + "' ";
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
this.cinText.Text = reader["cinprof"].ToString();
this.nomText.Text = reader["Nom"].ToString();
this.telText.Text = reader["Tel"].ToString();
this.emailText.Text = reader["Email"].ToString();
this.titreText.Text = reader["Titre"].ToString();
this.cvText.Text = reader["CV"].ToString();
}
}
this.rechercherText.Clear();
connection.Close();
}
public void reset()
{
cinText.Enabled = true;
cinText.Clear(); cvText.Clear();
titreText.Clear(); telText.Clear();
nomText.Clear(); emailText.Clear();
Telecharger.Hide();
}