How to get raw data generated by connector?

Scheduler Javascript
#1

I am using Asp.net Domain. i want to know whether Data retrieved from Database or not.
because i am trying Stored Procedure in Connector, it dose not show any error but none of the events are not loaded. so i want to know whether my code is right or not and how to get raw data while in debug mode in visual studio…

Asp.Net Code:

public override IdhtmlxConnector CreateConnector(HttpContext context)
{
var connector = new dhtmlxSchedulerConnector(
string.Format(“EXECUTE SelectEvents ‘{0}’”, Tools.EscapeQueryValue((context.Request.QueryString[“tag”] != null) ? context.Request.QueryString[“tag”] : “”)),
“”,
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings[“SamplesDatabase”].ConnectionString
, “FromDate”
, “ToDate”
, “Subject as text, Details as details, Tags, Custom”
);
}

Database Code:
Create PROCEDURE [dbo].[SelectEvents]
@tag nvarchar(20) = ‘’
AS
select EventID, FromDate, ToDate, Subject from Events
RETURN

Please help me soon

#2

Hello,
there is no easy way to do it from outside the connector,
but you can add connectors project (dhtmlxConnector.NET.csproj) to your solution instead of precompiled dll, so you’re be able to debug it.
In the connectors project, please open DatabaseAdapter.cs file and find following place screencast.com/t/8cuoYFH5N this is where the selection is done.

#3

Is this my following codes are right for running Stored Procedure?
For me stored procedure used in grid page is working fine but when i tried the same code for scheduler mean it didnt show the events in scheduler and also no error.

Please help me to get output

Asp.Net Code:

public override IdhtmlxConnector CreateConnector(HttpContext context)
{
dhtmlxSchedulerConnector connector = new dhtmlxSchedulerConnector(
string.Format(“EXECUTE SelectEvents ‘{0}’”, Tools.EscapeQueryValue((context.Request.QueryString[“tag”] != null) ? context.Request.QueryString[“tag”] : “”)),
“”,
dhtmlxDatabaseAdapterType.SqlServer2005,
ConfigurationManager.ConnectionStrings[“SamplesDatabase”].ConnectionString
, “FromDate”
, “ToDate”
, “Subject as text, Details as details, Tags, Custom”
);
}

Database Code:
Create PROCEDURE [dbo].[SelectEvents]
@tag nvarchar(20) = ‘’
AS
select EventID, FromDate, ToDate, Subject from Events
RETURN

#4

Hello,
the list of columns in configuration of your connector includes Details, Tags and Custom columns, which are not selected by your stored procedure.
Probably this is the reason