passing parameter to stored procedure

Scheduler Javascript
#1

how to pass parameter value to stored procedure, in dhtmlxSchedular ddl file

#2

Hi,
if you mean calling stored procedures from ADO.NET, this is not exactly related to dhtmlxScheduler but you may check this article
msdn.microsoft.com/en-us/library … 8(v=vs.110.aspx

If you mean something else - please elaborate your question

#3

Hi,
thanks for ur reply. My question is that,
in following code the SELECT query is too long, so instead of this query, i want to call my stored procedure ([sp_myschedular]) with two parameter (@filter1 & @filter2). how can i do this

dhtmlxSchedulerConnector connector = new dhtmlxSchedulerConnector(
“Select Tbl_ProjectCode_Master.PcId, Tbl_ProjectCode_Master.ProjectCode, isnull(Tbl_Distributor_Master.DistName,Tbl_Company_Master.CompName) as DistName, Case WHEN Tbl_ProjectCode_Master.[Status] = 1 THEN ‘Open’ WHEN Tbl_ProjectCode_Master.[Status] = 2 THEN ‘InProgress’ WHEN Tbl_ProjectCode_Master.[Status] = 0 THEN ‘Close’ END as ProjectStatus, Case WHEN Tbl_ProjectCode_Master.[Status] = 1 THEN ‘black’ WHEN Tbl_ProjectCode_Master.[Status] = 2 THEN ‘green’ WHEN Tbl_ProjectCode_Master.[Status] = 0 THEN ‘orange’ END as color, Case WHEN Tbl_ProjectCode_Master.[Status] = 1 THEN ‘red’ WHEN Tbl_ProjectCode_Master.[Status] = 2 THEN ‘white’ WHEN Tbl_ProjectCode_Master.[Status] = 0 THEN ‘black’ END as textColor from Tbl_ProjectCode_Master inner join Tbl_Company_Master on Tbl_Company_Master.CompCode = Tbl_ProjectCode_Master.CompCode inner join tbl_Resource_Allocation on tbl_Resource_Allocation.Project_Code=Tbl_ProjectCode_Master.PcId inner join Tbl_Nature_Master on Tbl_Nature_Master.NatureId = Tbl_ProjectCode_Master.NatureId inner join tbl_Company_Area on tbl_Company_Area.CompCode = Tbl_Company_Master.CompCode AND tbl_Company_Area.Comp_AreaCode = Tbl_ProjectCode_Master.AreaCode inner join Tbl_Unit_Master on Tbl_Unit_Master.UnitId = Tbl_ProjectCode_Master.UnitID left join Tbl_Distributor_Master on Tbl_Distributor_Master.DistCode = Tbl_ProjectCode_Master.DistCode AND Tbl_Distributor_Master.CompCode = Tbl_ProjectCode_Master.CompCode”
, “Resource_id”
, dhtmlxDatabaseAdapterType.SqlServer2005
, ConfigurationManager.ConnectionStrings[“ResourceConn”].ConnectionString
, “Resource_start_date”
, “Resource_end_date”
, "ProjectCode as text, CompName, NatureName, MonthYear, Comp_AreaName
);
return connector;

#4

Hi,
check this file in dhtmlxConnectors package:
connector-net\samples\dhtmlxGrid\13_stored_procedure.ashx.cs
It is an example of usage stored procedures with dhtmlxGrid connector, the code for the scheduler will be the similar

#5

i didnt have 13_stored_procedure.ashx.cs file in my connector folder. can u please provide the link or file

#6

try this package
s3.amazonaws.com/uploads.hipcha … 141129.zip

#7

i download the connector-net-141129.zip file (above link).

Solution (Asp files ) is working fine but databse(Sample.mdf) is not opened because i am using lower version 655 but your version is 706…

1 ) So can you please provide the support version database for me?

  1. Is this SELECTEVENTS ‘{0}’ is a stored procedure name?
    " string.Format(“EXECUTE SELECTEVENTS ‘{0}’”, Tools.EscapeQueryValue((context.Request.QueryString[“tag”] != null) ? context.Request.QueryString[“tag”] : “”)), "

  2. i use the following code, it showing Error “Incorrect syntax near the keyword ‘Execute’”

         dhtmlxSchedulerConnector connector = new dhtmlxSchedulerConnector(
         string.Format("EXECUTE SelectEvents")
        , ..........
        , ......
#8

i am waiting for reply…