private void Form1_Load(object sender, EventArgs e) { DatabaseConnection.getconnection(); //check options radioButtoncheck(); // b = true; RecordQuestion r = DatabaseConnection.getquestions(); DatabaseConnection.n++; labelID.Text = "" + r.questionId; labelName.Text = r.questions; labelOa.Text = r.qOpa; labelOb.Text = r.qOpb; LabelOc.Text = r.qOpc; qOpANS = r.qOpANS; label5.Text = DatabaseConnection.stnameG; if (DatabaseConnection.testcomplete) { panel1.Visible = true; button1.Enabled = false; totalm = totalq * 10; int per = (Int32.Parse(obmarks.Text) * 100) / totalm; int incq = totalq - correctq; DateTime d = DateTime.Now; string date = d.ToString(); DatabaseConnection.insertResult(DatabaseConnection.stnameG, DatabaseConnection.emailadressG, (totalm).ToString(), obmarks.Text, (per).ToString(), (totalq).ToString(), (correctq).ToString(), (incq).ToString(), date); } }
public static RecordQuestion getquestions() { string query = "select * from question where questionid=" + n; con.Open(); OleDbCommand com = new OleDbCommand(query, DatabaseConnection.con); OleDbDataReader read = com.ExecuteReader(); RecordQuestion rec = new RecordQuestion(); testcomplete = true; if (read.Read()) { rec.questionId = read.GetInt32(0); rec.questions = read.GetString(1); rec.qOpa = read.GetString(2); rec.qOpb = read.GetString(3); rec.qOpc = read.GetString(4); rec.qOpANS = read.GetString(5); testcomplete = false; } con.Close(); return(rec); }