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