public void Edit(Question item, int pos) { DB.Tables[0].Rows[pos]["question"] = item.Question_; DB.Tables[0].Rows[pos]["trueAnswer"] = item.Get_true_answer(); DB.Tables[0].Rows[pos]["answer2"] = item.Get_Answer(1); DB.Tables[0].Rows[pos]["answer3"] = item.Get_Answer(2); DB.Tables[0].Rows[pos]["answer4"] = item.Get_Answer(3); Save(); }
public void Add(Question item) { DataRow row = DB.Tables[0].NewRow(); row["id"] = DB.Tables[0].Rows.Count; row["question"] = item.Question_; row["trueAnswer"] = item.Get_true_answer(); row["answer2"] = item.Get_Answer(1); row["answer3"] = item.Get_Answer(2); row["answer4"] = item.Get_Answer(3); DB.Tables[0].Rows.Add(row); Save(); }
public void Add(Question item) { string Expression = string.Format("INSERT INTO mainTable (question, trueAnswer, answer2, answer3, answer4) values ('{0}', '{1}', '{2}', '{3}', '{4}')", item.Question_, item.Get_Answer(0), item.Get_Answer(1), item.Get_Answer(2), item.Get_Answer(3)); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(Expression, connection); int num = command.ExecuteNonQuery(); } Load(_list); }
public void Edit(Question item, int pos) { _list[pos].Question_ = item.Question_; for (int i = 0; i < 4; i++) _list[pos].Set_Answer(i, item.Get_Answer(i)); }
public void Edit(Question item, int pos) { int num; string ExpU = string.Format("update mainTable set question = '{0}', trueAnswer = '{1}', answer2 = '{2}', answer3 = '{3}', answer4 = '{4}' where question like '{4}'", item.Question_, item.Get_Answer(0), item.Get_Answer(1), item.Get_Answer(2), item.Get_Answer(3), _list[pos].Question_); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(ExpU, connection); num = command.ExecuteNonQuery(); if(num == 0) throw new Exception(num + " items updated"); } Load(_list); }
public void SetNewQuestion(Question item) { _LastClick.Image = million.Properties.Resources.button; _answers_name[Convert.ToInt32(_LastClick.Name[_LastClick.Name.Length - 1].ToString()) - 1].Image = million.Properties.Resources.button; friend.Visible = false; friend_answer.Visible = false; layer_auditory.Visible = false; QUESTION.Text = item.Question_; for (int i = 0; i < 4; i++) { _answers[i].Text = item.Get_Answer(i); if (_fify_fifty) _answers_name[i].Visible = true; } _fify_fifty_used = false; _clicked = false; }