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();
}
}