FilterExpression

bernard — Mon, 20 May 2013 01:40:45 GMT

Hi Adam,

This issue happen because FilterExpression wasn't added to Select Method in when WebScheduler rendered. However, You can use my method to add Filter Expression in Select Method. If you have any further question, please don't hesitate to ask us.

Regards,
Bernard

FilterExpression

siemiatkowski@softwarestudio.com.pl — Fri, 17 May 2013 06:10:08 GMT

Thx, I ran your example, I think its work fine

So I'll try to use it, but I still dont know why

doesnt work.

However, your solution seems to me to be better

Adam

FilterExpression

bernard — Thu, 16 May 2013 09:22:20 GMT

Hi Adam,

To resolve this matter, you can use SelectParameter attribute in ISDataSource. When Selecting, ISDataSource will take SelectParameter value that parse to server side to filtering, sorting, and etc. I've made a simple sample for you. You can look in my sample and please let me know if this sample doesn't meet your requirement. Look forward to hear any feedback from you so I can help you further.

Regards,
Bernard

FilterExpression

siemiatkowski@softwarestudio.com.pl — Tue, 14 May 2013 02:59:17 GMT

I try to use

ISDataSource1.Tables.GetNamedItem("Events").FilterExpression = "subject='02'";

for ISWebScheduler

<ISWebScheduler:WebScheduler ID="WebScheduler1" runat="server" Height="100%"

Width="100%" DefaultStyleMode="Win7" Culture="Polish (Poland)"

CategoriesDataMember="Categories" DataSourceID="ISDataSource1"

EventsDataMember="Events" ResourcesDataMember="Resources" EnableFastJsonSerialization="True" >

<EventsBinding AllDayEventField="AllDayEvent" CategoryIDField="CategoryID"

DescriptionField="Description" EndTimeField="EndTime" EventIDField="ID"

LocationField="Location" ModeField="Mode" ReminderTimeSpanField="Reminder"

ResourceIDField="ResourceID" StartTimeField="StartTime"

SubjectField="Subject" />

I have not any error, but I have in my WebScheduler all data from table "events", the filter expression does not work ?

When I write wrong expression

ISDataSource1.Tables.GetNamedItem("Events").FilterExpression = "subjectx='02'";

I have an error, because the column subjectx absent

I try run with parametrs, but still the same,

ISDataSource1.Tables.GetNamedItem("Events").FilterExpression = " subject='{0}'";

ISDataSource1.Tables.GetNamedItem("Events").FilterParameters.Add("subject", "02");

any idea ?

My ISDataSource:ISDataSource

<ISDataSource:ISDataSource ID="ISDataSource1" runat="server" SchemaName="StudioSystem.App_Code.kalendarz" >

<ISDataSource:ISDataSourceTable SelectMethod="GetData" OldValuesParameterFormatString="Original_{0}"

TableName="Events" TypeName="StudioSystem.App_Code.kalendarzTableAdapters.EventsTableAdapter" DeleteMethod="Delete" InsertMethod="Insert" UpdateMethod="Update">

<asp:Parameter Name="Original_ID" Type="Int32" />

</DeleteParameters>

<asp:Parameter Name="CategoryID" Type="String" />

<asp:Parameter Name="ResourceID" Type="Int32" />

<asp:Parameter Name="Mode" Type="Int32" />

<asp:Parameter Name="Subject" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Location" Type="String" />

<asp:Parameter Name="AllDayEvent" Type="Boolean" />

<asp:Parameter Name="StartTime" Type="DateTime" />

<asp:Parameter Name="EndTime" Type="DateTime" />

<asp:Parameter Name="Reminder" Type="Int32" />

<asp:Parameter Name="ReminderTimeSpan" Type="Int32" />

</InsertParameters>

<asp:Parameter Name="CategoryID" Type="String" />

<asp:Parameter Name="ResourceID" Type="Int32" />

<asp:Parameter Name="Mode" Type="Int32" />

<asp:Parameter Name="Subject" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Location" Type="String" />

<asp:Parameter Name="AllDayEvent" Type="Boolean" />

<asp:Parameter Name="StartTime" Type="DateTime" />

<asp:Parameter Name="EndTime" Type="DateTime" />

<asp:Parameter Name="Reminder" Type="Int32" />

<asp:Parameter Name="ReminderTimeSpan" Type="Int32" />

<asp:Parameter Name="Original_ID" Type="Int32" />

</UpdateParameters>

</ISDataSource:ISDataSourceTable>

Adam

Intersoft Community - ISDataSource - FilterExpression

FilterExpression

FilterExpression

FilterExpression

FilterExpression