private void loadItemsFromDB() { // UsernameBox.Items.Clear(); foreach (string database in globalvariables.DatabaseLocations) { using (SQLiteConnection sqlite_connection = new SQLiteConnection("Data Source=" + database + ";Version=3;")) { sqlite_connection.Open(); string sql = "select V_Key,Stig_Name,System_Name,entryID,transactionID,commentText,userID from Comments;"; using (SQLiteCommand command = new SQLiteCommand(sql, sqlite_connection)) { using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { CommentEntry ce = new CommentEntry(); ce.Comment = (string)reader["commentText"]; ce.UserID = reader["userID"] as string ?? ""; if (!UserAccounts.Contains(reader["userID"] as string)) { UserAccounts.Add(reader["userID"] as string); } ce.TransactionID = reader["transactionID"] as string ?? ""; ce.EntryID = reader["entryID"] as string ?? ""; ce.System_Name = reader["System_Name"] as string ?? ""; ce.Stig_Name = reader["Stig_Name"] as string ?? ""; ce.V_Key = reader["V_Key"] as string ?? ""; Comments.Add(ce); } reader.Close(); sqlite_connection.Close(); command.Dispose(); } } } } }