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

private void radioButton4_CheckedChanged(object sender, EventArgs e)

{
try
{

if (radioButton4.Checked == true)
{
listView1.Items.Clear();

var MConn = new MySqlConnection(strCnn);

MConn.Open();

var Comm = new MySqlCommand("select * from work order by no desc;",
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";

}
}

- 644 -