public void ReFresh() { txtID.Text = ""; txtUser.Text = ""; txtFullname.Text = ""; txtAccount.Text = ""; txtPassword.Text = ""; btnUpdate.Enabled = true; txtID.Enabled = true; button6.Text = "New"; txtAccountCode.Text = ""; txtAccountDesc.Text = ""; button5.Enabled = true; ServerConnection server = new ServerConnection(); listView1.Items.Clear(); listView2.Items.Clear(); txtAccount.Items.Clear(); #region Get the Acnt User try { string sqlAdd = "select * from acnt_usr a join usr_scrty_qustn b on a.usr_id = b.user_id order by a.usr_id;"; server.Connection(); MySqlCommand cmd = new MySqlCommand(sqlAdd, server.con); MySqlDataReader read; server.OpenConnection(); read = cmd.ExecuteReader(); while (read.Read()) { ListViewItem item = new ListViewItem(read["usr_id"].ToString()); item.SubItems.Add(read["usr_name"].ToString()); item.SubItems.Add(read["usr_fullname"].ToString()); item.SubItems.Add(read["usr_rspnsblty"].ToString()); item.SubItems.Add(read["usr_password"].ToString()); item.SubItems.Add(read["usr_question"].ToString()); item.SubItems.Add(read["usr_answer"].ToString()); listView1.Items.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Contact Administrator or POS provider", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion #region Get The Acnt Responsibility try { string sqlAdd = "SELECT * FROM acnt_rspnsblty"; server.Connection(); MySqlCommand cmd = new MySqlCommand(sqlAdd, server.con); MySqlDataReader read; server.OpenConnection(); read = cmd.ExecuteReader(); while (read.Read()) { txtAccount.Items.Add(read["acnt_code"].ToString()); ListViewItem item = new ListViewItem(read["acnt_code"].ToString()); item.SubItems.Add(read["acnt_desc"].ToString()); listView2.Items.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Contact Administrator or POS provider", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }