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

}

myRead.Close();
readbox.Text += "[Tools] Number - Descending -> Sorting changed\n";
}

}
catch (MySqlException error_3)
{

MessageBox.Show(error_3.Message);
radioButton4.Checked = false;
}

}

//RadioButton Date[desc] 체크시
private void radioButton6_CheckedChanged(object sender, EventArgs e)
{

try
{
if (radioButton6.Checked == true)
{

listView1.Items.Clear();

var MConn = new MySqlConnection(strCnn);
MConn.Open();

var Comm = new MySqlCommand("select * from work order by whend
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);
}

- 645 -