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

}

}

//RadioButton Check[NO] 체크시

private void radioButton8_CheckedChanged(object sender, EventArgs e)
{
try
{
if (radioButton8.Checked == true)

{
listView1.Items.Clear();

var MConn = new MySqlConnection(strCnn);
MConn.Open();
var Comm = new MySqlCommand("select * from work where checkd='NO';",
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

- 648 -