passing parameter to stored procedure

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

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

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;

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

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

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

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")
            , ..........
            , ......

i am waiting for reply…