Page 641 - 완) I MDP 프로젝트 작품 보고서(전체과 1학년)1.6

var myRead = Comm.ExecuteReader();

while (myRead.Read())
{
string[] data = {myRead["no"].ToString(), myRead["keyd"].ToString(),

myRead["checkd"].ToString() , myRead["whend"].ToString()};

var listviewItem = new ListViewItem(data);
listView1.Items.Add(listviewItem);

}

ListViewItem item = new ListViewItem();

if (checkBox2.Checked == true)
{
for (int i = 0; i < listView1.Items.Count; ++i)
{
if (listView1.Items[i].SubItems[2].Text == "YES")

{
listView1.Items[i].SubItems[1].Text = "Authorized";
}
else

{
listView1.Items[i].SubItems[1].Text = "UnAuthorized";
}
}
}

myRead.Close();
textbox_clear();
readbox.Text += "[MySQL] Load Success\n";

}
catch (MySqlException e_1)
{
MessageBox.Show(e_1.Message);
}

finally
{
listView1.EndUpdate();

- 634 -