public DataTable GetForside() { string strSQL = "SELECT fldID, fldForside FROM tblForside"; SqlCommand objCMD = new SqlCommand(strSQL); return(objConn.GetData(objCMD)); }
public DataTable GetSavedGames() { string sql = "SELECT fldID, fldName, strftime('%d-%m-%Y %H:%M', fldCreationDate) AS Date FROM tbltown ORDER BY fldID DESC"; SQLiteCommand cmd = new SQLiteCommand(sql); return(db.GetData(cmd)); }