Beispiel #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            Espace_Agent F16 = new Espace_Agent();

            F16.Show();
            FormsApplication.AddForm(F16);
            this.Close();
        }
Beispiel #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string server           = "localhost";
            string database         = "GestionnaireSTL";
            string user             = "******";
            string connectionString = "database=" + database + "; server= " + server + ";user ="******"select * from compte where login = @login and mot_de_passe = @password";
            MySqlCommand cmd   = new MySqlCommand(query, cnx);

            cmd.Parameters.AddWithValue("@login", login);
            cmd.Parameters.AddWithValue("@password", password);
            MySqlDataReader rd = cmd.ExecuteReader();

            if (rd != null)
            {
                if (rd.Read())
                {
                    MessageBox.Show("Bienvenue " + rd[2] + " " + rd[3] + "!");
                    if ((string)rd[6] == "Admin")
                    {
                        cnx.Close();
                        Espace_Admin F3 = new Espace_Admin();
                        F3.Show();
                        FormsApplication.AddForm(F3);
                        this.Close();
                    }
                    else if ((string)rd[6] == "Agent")
                    {
                        cnx.Close();
                        Espace_Agent F16 = new Espace_Agent();
                        F16.Show();
                        FormsApplication.AddForm(F16);
                        this.Close();
                    }
                }
                else
                {
                    MessageBox.Show("Compte non existant!");
                }
            }
        }