/// <summary> /// Get list of all artworks /// </summary> /// <returns>DataTable of artworks</returns> public DataTable GetArtWorksList() { string sql = SelectStatement.Replace("Artists.LastName, ", " "); sql += " ORDER BY " + OrderByFields.Replace("YearOfWork,", " "); return(DataHelper.GetDataTable(sql, null)); }