I am using ASP NET AJAX Gantt contro with database provider. I have created a table according to documentation here: http://docs.telerik.com/devtools/aspnet-ajax/controls/gantt/data-binding/database-structure
It is a readonly control, only for display purposes, but I would like to filter rows in that table according to user selection (year selection is possible). I have just added a where clause:
'where [Start] between @startInterval and @endInterval
and [End] between @startInterval and @endInterval'
Even when I can see on Sqldatasource selectedEvent the affected rows >0 and fits the exact number of rows query should return, Gantt diagram displays empty.
If I remove the where clause, diagram displays perfectly.
Is there anything I am not taking into account?
Thank you in advance