private void DRadial_Checked(object sender, RoutedEventArgs e) { connectDB con = new connectDB(); player p = new player(); int qN = Convert.ToInt32(qNumberBox.Text.ToString()); DataTable dt = con.getQ(qN) as DataTable; string z = dt.Rows[0]["PoprawnaOdpowiedz"].ToString(); if (DRadial.Content.ToString() == z) { MessageBox.Show("Correct!"); p.addPoints(); } }
private void Button_Click(object sender, RoutedEventArgs e) { connectDB con = new connectDB(); try { //con.getQ(1); DataTable dt = con.getQ(2) as DataTable; MessageBox.Show(dt.Rows[0]["TrescPytania"].ToString()); } catch (Exception xe) { MessageBox.Show(xe.Message); } }
private void setQuestion(int qN) { connectDB con = new connectDB(); player p = new player(); DataTable dt = con.getQ(qN) as DataTable; string q = "SELECT MAX(NumerPytania) FROM matura;"; DataTable cdt = con.customSelect(q); // Select MAX("NumerPytania") FROM matura; allQuestion.Text = cdt.Rows[0][0].ToString(); qNumberBox.Text = dt.Rows[0]["NumerPytania"].ToString(); if (Convert.ToInt32(qNumberBox.Text) == Convert.ToInt32(allQuestion.Text)) { finishBtn.IsEnabled = true; } questionBox.Text = dt.Rows[0]["TrescPytania"].ToString(); answerA.Text = dt.Rows[0]["OdpowiedzA"].ToString(); answerB.Text = dt.Rows[0]["OdpowiedzB"].ToString(); answerC.Text = dt.Rows[0]["OdpowiedzC"].ToString(); answerD.Text = dt.Rows[0]["OdpowiedzD"].ToString(); }