private void OnQueryDatabase_Click(object sender, EventArgs e) { string commandText; List <string> parameters; CreateSQLQueryToRun(out commandText, out parameters); SQLiteDataReader sqlReader; try { if (parameters.Count == 0) { sqlReader = dbQuery.QueryDatabase(commandText, null, null); } else { sqlReader = dbQuery.QueryDatabase(commandText, parameters, extensionChekboxItems.CheckedItems); } //Gets the results from Database.cs and then created the rows of the datagridview with the it. sqlDatabaseGridView.Rows.Clear(); while (sqlReader.Read()) { var rowid = sqlReader[0] + ""; var extension = sqlReader[1].ToString(); var filename = sqlReader[2].ToString(); var path = sqlReader[3].ToString(); var eventType = sqlReader[4].ToString(); var dateTime = sqlReader[5].ToString(); string[] rowResults = new string[] { rowid, extension, filename, path, eventType, dateTime }; sqlDatabaseGridView.Rows.Add(rowResults); } if (sqlDatabaseGridView.Rows.Count == 0) { dataGridProgressLabel.Text = "There was nothing from the database that matched your query!"; } else { dataGridProgressLabel.Text = "Successfully queried for extensions!"; } //ADD CHECK TO SEE IF ANYTHING WAS ADDED ELSE PUT SOMETHING SOMEWHERE TO INDICATE THERE WASN'T sqlReader.Close(); }catch (Exception ex) { Console.WriteLine(ex.Message); } }