iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
Hi
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" >
<DataBinding>
<EventsBinding AllDayEventField="AllDayEvent" CategoryIDField="CategoryID"
DescriptionField="Description" EndTimeField="EndTime" EventIDField="ID"
LocationField="Location" ModeField="Mode" ReminderTimeSpanField="Reminder"
ResourceIDField="ResourceID" StartTimeField="StartTime"
SubjectField="Subject" />
So
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" >
<tables>
<ISDataSource:ISDataSourceTable SelectMethod="GetData" OldValuesParameterFormatString="Original_{0}"
TableName="Events" TypeName="StudioSystem.App_Code.kalendarzTableAdapters.EventsTableAdapter" DeleteMethod="Delete" InsertMethod="Insert" UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_ID" Type="Int32" />
</DeleteParameters>
<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" />
</InsertParameters>
<UpdateParameters>
</UpdateParameters>
</ISDataSource:ISDataSourceTable>
Adam
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
Thx, I ran your example, I think its work fine
So I'll try to use it, but I still dont know why
<FilterParameters></FilterParameters>
doesnt work.
However, your solution seems to me to be better
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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname