Page 649 - 완) I MDP 프로젝트 작품 보고서(전체과 1학년)1.6
P. 649
if (listView1.Items[i].SubItems[2].Text == "YES")
{
listView1.Items[i].SubItems[1].Text = "Authorized";
}
else
{
listView1.Items[i].SubItems[1].Text = "UnAuthorized";
}
}
}
readbox.Text += "[Tools] Number - Ascending -> Sorting changed\n";
myRead.Close();
}
listView1.EnsureVisible(listView1.Items.Count - 1);
}
catch (MySqlException error)
{
MessageBox.Show(error.Message);
radioButton1.Checked = false;
}
}
//RadioButton Date[asc] 체크시
private void radioButton3_CheckedChanged(object sender, EventArgs e)
{
try
{
if (radioButton3.Checked == true)
{
listView1.Items.Clear();
var MConn = new MySqlConnection(strCnn);
MConn.Open();
var Comm = new MySqlCommand("select * from work order by whend asc;",
MConn);
var myRead = Comm.ExecuteReader();
- 642 -