Hello,
I use .net Connector to retrieve data from a SQL Server database using this code :
Dim connector = New dhtmlxSchedulerConnector("EVENTI", "ID", dhtmlxDatabaseAdapterType.SqlServer2005, HelperConfig.ConnectionString, "FROM_DATE", "TO_DATE", "TEXT")
And this is my init function:
[code][/code]
With the log enabled I’m sure that the table is read.
Below the log :
16:04:09 DataRequest: Processing client request. QueryString: timeshift=-120, Form:
16:04:09 DataRequest: Resolving type of request.
16:04:09 DataRequest: Processing client select.
16:04:09 dhtmlxSchedulerConnector: Rendering response
16:04:09 DataRequest: Enterering Render method.
16:04:09 DataRequest: Calling BeforeSelect event
16:04:09 DataRequest: Selecting data.
16:04:09 MSSQLAdapter: Entering: ExecuteSelectQuery
16:04:09 MSSQLAdapter: Creating SelectQuery from TableName: EVENTI, Fields: ID, TEXT, FROM_DATE, TO_DATE, Rules: , OrderBy: , StartIndex: 0, Count: 0
16:04:09 MSSQLAdapter: Select query: SELECT ID, TEXT, FROM_DATE, TO_DATE FROM EVENTI
16:04:09 MSSQLAdapter: Exiting: ExecuteSelectQuery
16:04:09 DataRequest: Selecting items count.
16:04:09 MSSQLAdapter: ExecuteGetCountQuery: TableName: EVENTI, RequesteFields: 1 as dummyValue, Rules:
16:04:09 MSSQLAdapter: Creating SelectQuery from TableName: EVENTI, Fields: 1 as dummyValue, Rules: , OrderBy: null, StartIndex: 0, Count: 0
16:04:09 MSSQLAdapter: Select query: SELECT 1 as dummyValue FROM EVENTI
16:04:09 MSSQLAdapter: Result: 2
16:04:09 DataRequest: Calling AfterSelect event
16:04:09 dhtmlxSchedulerConnector: Rendering 'Select' result
16:04:09 dhtmlxSchedulerConnector: Rendering children
16:04:09 dhtmlxSchedulerConnector: Converting DataRow object to connector specific data items
16:04:09 dhtmlxSchedulerConnector: Closing response
16:04:09 dhtmlxSchedulerConnector: Calling End event
My problem is that the events are not visible in the scheduler.
What I’m doing wrong ?
Thanks for your help!