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