Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            String username;

            username = comboBox1.SelectedItem.ToString();
            File.WriteAllText("System.FileType.txt", username);
            MessageBox.Show("Welcome, " + username.Trim());
            SystemApplication sa = new SystemApplication();

            sa.ShowDialog();
            return;
        }
Exemplo n.º 2
0
        private void connection()
        {
            string          connectionString = ("Server=localhost;user id=db_user;password=microsoft;Database=traininglog;");
            MySqlConnection con        = new MySqlConnection(connectionString);
            string          userscript = "SELECT password FROM table_one WHERE username='******';";
            MySqlCommand    command    = new MySqlCommand(userscript, con);

            con.Open();
            if (username.Text == "administrator")
            {
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    if (reader["password"].ToString() == password.Text.Trim())
                    {
                        File.WriteAllText("System.FileType.txt", username.Text);
                        MessageBox.Show("Welcome, " + username.Text.Trim());
                        Form form3 = new Form3();
                        form3.ShowDialog();
                        return;
                    }
                }
            }
            else
            {
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    if (reader["password"].ToString() == password.Text.Trim())
                    {
                        File.WriteAllText("System.FileType.txt", username.Text);
                        MessageBox.Show("Welcome, " + username.Text.Trim());
                        SystemApplication sa = new SystemApplication();
                        sa.ShowDialog();
                        return;
                    }
                }
            }

            MessageBox.Show("Sorry, You have entered incorrect login information.");
        }