private void GetQuestions() { sql = new SqlConnection(conMod); sql.Open(); string competence = "SELECT * FROM Questions"; SqlDataAdapter adapter = new SqlDataAdapter(competence, sql); DataSet ds = new DataSet(); adapter.Fill(ds); try { ChooseQuestionCheckedList.DataSource = ds.Tables[0]; ChooseQuestionCheckedList.DisplayMember = "QuestionText"; ChooseQuestionCheckedList.ValueMember = "QuestionID"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (Convert.ToBoolean(ds.Tables[0].Rows[i][4]) == true) { ChooseQuestionCheckedList.SetItemChecked(i, true); } else { ChooseQuestionCheckedList.SetItemChecked(i, false); } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } for (int i = 0; i < ChooseQuestionCheckedList.Items.Count; i++) { ChooseQuestionCheckedList.SetSelected(i, false); } }
private void ChooseQuestionCheckedList_ItemCheck(object sender, ItemCheckEventArgs e) { if (ChooseQuestionCheckedList.GetItemChecked(ChooseQuestionCheckedList.SelectedIndex) == true) { sql = new SqlConnection(conMod); sql.Open(); string up = "UPDATE Questions SET Active='False' WHERE QuestionID=" + ChooseQuestionCheckedList.SelectedValue; SqlCommand Ins = new SqlCommand(up, sql); Ins.ExecuteNonQuery(); GetListsOfQuestions(); } else { sql = new SqlConnection(conMod); sql.Open(); string up = "UPDATE Questions SET Active='True' WHERE QuestionID=" + ChooseQuestionCheckedList.SelectedValue; SqlCommand Ins = new SqlCommand(up, sql); Ins.ExecuteNonQuery(); GetListsOfQuestions(); } }