/// <summary>
/// Returns all data from a table and stores it in a DataSet using Control.Database.SQLite3
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public DataSet GrabData(string table)
{
string _command = $"SELECT * FROM {table};";
DataSet data = new DataSet();
using (DbCommand command = FileConnection.CreateCommand())
{
DatabaseProfile profile = new DatabaseProfile("sqlite", constr, "SQLite 3");
SQLiteQuery query = new SQLiteQuery(profile);
command.CommandText = _command;
command.CommandType = CommandType.Text;
data = query.Execute(command);
}
Console.Clear();
return(data);
}