1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| private void UtilisateurForm_Load(object sender, EventArgs e)
{
MySqlDataAdapter dadpter = new MySqlDataAdapter("select * from utilisateur", "server=localhost;userid=root;database=cabinet;password=");
DataSet dset = new DataSet();
dadpter.Fill(dset);
idcombo.DataSource = dset.Tables[0];
idcombo.DisplayMember = "ID_UTILISATEUR";
idcombo.ValueMember = "ID_UTILISATEUR";
}
private void idcombo_SelectedIndexChanged(object sender, EventArgs e)
{
string sql;
MySqlConnection cn = new MySqlConnection();
cn.ConnectionString = "server=localhost;userid=root;database=cabinet;password=";
cn.Open();
sql = "SELECT NOM_UTILISATEUR FROM utilisateur WHERE(ID_UTILISATEUR='" + idcombo.SelectedValue + "')";
MySqlCommand cmd = new MySqlCommand(sql, cn);
MySqlDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
nomtext.Text = myReader["NOM_UTILISATEUR"].ToString();
}
myReader.Close();
cn.Close();
} |
Partager