Ejemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            var dt = ConecctionDB.ExecuteQuery("SELECT pl.name, sc.score " +
                                               "FROM PLAYER pl, SCOREBOARD sc " +
                                               "WHERE pl.idscore = sc.idscore order by sc.score desc " +
                                               "LIMIT 10");

            dataGridView1.DataSource = dt;
        }
Ejemplo n.º 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            var name = txtName.Text;

            if (name.Length == 0)
            {
                MessageBox.Show("you did not enter the name!", "Name Empty",
                                MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            else
            {
                //verificacion con la base de datos por si esta repetido
                var dt = ConecctionDB.ExecuteQuery("SELECT Name " +
                                                   "FROM PLAYER");

                foreach (DataRow dr in dt.Rows)
                {
                    if (dr[0].ToString().Equals(txtName.Text))
                    {
                        MessageBox.Show("The name already exist", "name repeated",
                                        MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

                        Continue = false;
                        break;
                    }
                }

                //luego se inicia el juego
                if (Continue == true)
                {
                    ConecctionDB.ExecuteNonQuery("INSERT INTO PLAYER(Name) " +
                                                 $"VALUES('{txtName.Text}')");
                    Game game = new Game();
                    game.Show();
                    this.Close();
                }
            }
        }