SqlitePerson.SelectAllPersons C# (CSharp) Method

SelectAllPersons() public static method

public static SelectAllPersons ( ) : ArrayList
return ArrayList
    public static ArrayList SelectAllPersons()
    {
        Sqlite.Open();
        dbcmd.CommandText = "SELECT uniqueID, name FROM " + Constants.PersonTable;

        SqliteDataReader reader;
        reader = dbcmd.ExecuteReader();

        ArrayList myArray = new ArrayList(1);

        while(reader.Read())
            myArray.Add ("(" + reader[0].ToString() + ") " + reader[1].ToString());

        reader.Close();
        Sqlite.Close();

        return myArray;
    }