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

MConn.Open();

var Comm = new MySqlCommand("select * from work where checkd='YES';",
MConn);
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();
listView1.EnsureVisible(listView1.Items.Count - 1);

readbox.Text += "[Tools] Check - 'YES' -> Sorting changed\n";
}
}
catch (MySqlException error_5)
{

MessageBox.Show(error_5.Message);
radioButton7.Checked = false;

- 647 -