ANHAdmin.frmAccounts.listaccts C# (CSharp) Method

listaccts() public method

public listaccts ( ) : void
return void
        public void listaccts()
        {
            MySqlConnection conGet = new MySqlConnection(MySQLRunner.ConnectionString);
            MySqlDataReader drGet = null;
            string sSQL = "";
            sSQL = "SELECT * FROM account";

            if (MySQLRunner.ExecuteQuery(sSQL, conGet, ref drGet) == true)
            {
                ListViewItem lsvItem;
                while (drGet.Read())
                {
                    lsvItem = new ListViewItem(drGet.GetString(drGet.GetOrdinal("username")));
                    lsvItem.Tag = drGet.GetString(drGet.GetOrdinal("account_id"));
                    lsvAccounts.Items.Add(lsvItem);
                }
            }
            else
            {
                MessageBox.Show("Error connecting to the database.");
            }

            if (conGet.State == ConnectionState.Open)
            {
                if (drGet != null)
                    drGet.Close();

                conGet.Close();
            }
        }