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
Our common scenario for WebValueList column is using WebCombo edit type. For example, our EditorTypes.aspx page in WebGrid sample which WebValueList in SupplierID and CategoryID column. Please enable filtering by setting the AllowFilter property to true.
We could also use CustomFiltering which already explained in the WebGrid Documentaion under the article "CustomFilter Event". However, using this approach you will need to have the DataText WebValueList as a hidden column.
Hi Glenn
Thank you for advise.
It's possible to sort Items alphabetically if I use Dropdownlist?
I use following Dateformat "dd.MM.yyyy hh:mm:ss". AutoFilterSuggestion for Date (e.g. Today, Yesterday, ... -> in Contextmenu) doesn't work. I have set LanguageMode to UseCulture:
e.Layout.TextSettings.Language = LanguageMode.UseCulture; e.Layout.TextSettings.UseWebResources = false; e.Layout.TextSettings.LocalizationFolder = @"~/Localization/";
WebCombo with ValueList has following Items:
Now I want to filter by ProductA.
Is there a way to choose more then one Item (like sample Multiple Values in WebValueList) or set Filtertext to e.g. ProductA*?
Best regards
Michael
You use sort the item alphabethically on EditType dropdownlist column if you are using WebValueList, just set the property UseValueListForSorting to true to sort it by tthe text value.
AutoFilterSuggestion will work with any dateformat if the column datatype is DateTime and the formatting is done using DataFormatString property of the WebGridColumn. For example here is the snippet to format column RequiredDate to displayed as "dd.MM.yyyy hh:mm:ss":
<ISWebGrid:WebGridColumn Caption="RequiredDate" DataMember="RequiredDate" DataType="System.DateTime" EditType="CalendarCombo" Name="RequiredDate" Width="100px" DataFormatString="dd.MM.yyyy hh:mm:ss"></ISWebGrid:WebGridColumn>
Please execute the columnset creation code once. In the sample you attached, the columnset will be created each time PrepareDataBinding is triggered, if you only execute the code once (while page is not PostBack) the page will display without any issue.
You could try using AdvancedFilterExpression by disabling AutomaticFilter in the RootTable and handling the WebGrid filtering yourself in order to achieve filtering more than one item. Attached is a similar sample of filtering more than one City or Country
I have still problem with AutoFilterSuggestion. Following code is from sample AutomaticFilterSuggestion.aspx. I have added property DataFormatString="dd.MM.yyyy HH:mm:ss" on columns BirthDate and HireDate. Please check this. I get Errormessages like attached pictures.
<ISWebGrid:WebGrid ID="WebGrid1" runat="server" Height="300px" UseDefaultStyle="True" Width="100%" DataSourceID="AccessDataSource1"> <RootTable DataKeyField="EmployeeID"> <Columns> <ISWebGrid:WebGridColumn Caption="LastName" DataMember="LastName" Name="LastName" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="FirstName" DataMember="FirstName" Name="FirstName" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Title" DataMember="Title" Name="Title" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="TitleOfCourtesy" DataMember="TitleOfCourtesy" Name="TitleOfCourtesy" Width="100px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="BirthDate" DataMember="BirthDate" DataType="System.DateTime" Name="BirthDate" Width="200px" DataFormatString="dd.MM.yyyy HH:mm:ss"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="HireDate" DataMember="HireDate" DataType="System.DateTime" Name="HireDate" Width="200px" DataFormatString="dd.MM.yyyy HH:mm:ss"> </ISWebGrid:WebGridColumn> </Columns> </RootTable> <LayoutSettings AutoFilterSuggestion="True"> </LayoutSettings> </ISWebGrid:WebGrid>
In our environment the sample return no row and there is no such error as you described. Could you inform us the WebGrid build and WebUI Framework you are using in order to analyze this issue further.
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