hello every one,
Please help me…I designed an asp.net page…i want to fetch data from DB conditionally via SQL query and display on event light box.
Here is my code in
[WebService(Namespace = “http://tempuri.org/”)]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class schedulerConnector : dhtmlxRequestHandler
{
public override IdhtmlxConnector CreateConnector(HttpContext context)
{
return new dhtmlxSchedulerConnector(
"SELECT * FROM Events WHERE Details != ISD "
, “EventID”
, dhtmlxDatabaseAdapterType.SqlServer2005
, ConfigurationManager.ConnectionStrings[“SamplesDatabase”].ConnectionString
, “FromDate”
, “ToDate”
, “Subject as text, Details as details, Tags”
);
}
}
Please help yaro…
This is a schedularConnector.ashx.cs file…
The red color font is my query.It does not fetc the data like Details!=ISD…It fetched all data.
Any suggestion is welcomed…