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();
}
}
