private void afrikaansToolStripMenuItem_Click(object sender, EventArgs e) { //change program menu text and disable other game buttons this.Text = "Margana - Afrikaans"; englishToolStripMenuItem.Enabled = false; germanToolStripMenuItem.Enabled = false; portugueseToolStripMenuItem.Enabled = false; string lc_realWord = ""; //enable game buttons btnNextWord.Enabled = true; btnScrambleWord.Enabled = true; btnSubmit.Enabled = true; //get words from database mySQL lc_mySQLConnection = new mySQL(); //create class instance lc_mySQLConnection._OpenConnection(); //create sql connection MySqlDataReader lc_sqlResult = lc_mySQLConnection._getWords("Afrikaans"); //get all afrikaans words //add words to queue wordtracker lc_wordQueue = new wordtracker(); while (lc_sqlResult.Read()) { lc_wordQueue._addNewWord(lc_sqlResult.GetString(0).ToLower());//add word one at a time and convert to lower } lc_mySQLConnection._closeConnection(); //close mysql connection lblRealWord.Visible = false; lblRealWord.Text = "Real Word"; lc_realWord = lc_wordQueue.getNextWord(); // keep the word used in a seperate variable WordShuffler lc_wordShuffler = new WordShuffler(lc_wordQueue.getNextWord()); // shuffle current word string lc_shuffledWord = lc_wordShuffler.scramble(); gameTimer.Enabled = true; pauseGameToolStripMenuItem.Enabled = true; cheatToolStripMenuItem.Enabled = true; txtYourWord.Enabled = true; txtYourWord.Focus(); txtYourWord.Clear(); lblWord.Text = lc_shuffledWord; // temp lc_wordQueue.dequeueWord(); // remove first word from queue }
private void englishToolStripMenuItem_Click(object sender, EventArgs e) { mySQL lc_mySQLConnection = new mySQL(); //create class instance lc_mySQLConnection._OpenConnection(); //create sql connection lc_mySQLConnection._closeConnection(); //close mysql connection }