Intersoft Community - WebGrid Enterprise - Problem with filter not tolerent to error in format

Problem with filter not tolerent to error in format

Hans — Wed, 25 Jun 2014 22:49:39 GMT

Hello,

Basically, WebGrid’s main purpose is data presenter. WebGrid doesn’t handle any input validation. You should create your own input validation code.
There are couple ways to validate or reduce input errors.

The first option you could use “Edit Type” method or use “Integration with WebInput”, like Yudi said in his prior post.

The second you could add validation code in WebGrid’s client side events.
For example, there is “OnEditKeyDown” client side event. This event will be invoked when keypress is detected during editing mode (edit control is in focus).
Or “OnKeyUp” client side event, this event will be invoked when keypress is detected during editing mode (edit control is in focus).
Or “OnExitEditMode”, this event will be invoked when edit mode is being ended.

You could found more about ClientSideEvent in WebGrid’s documentation.
You could choose the client side event and add the validation code that suitable with your current scenario.

Regards,
Hans K.

Problem with filter not tolerent to error in format

aliard@sigma-rh.com — Wed, 25 Jun 2014 14:30:24 GMT

Thank you but I would like to know if you are going to resolve the issue about the grid not being able to manage an invalid date.

I think this should be addressed like a bug, the user must not see the error screen with all the stack.

Problem with filter not tolerent to error in format

Hans — Wed, 18 Jun 2014 02:58:22 GMT

Hello,

Thank you for the reply.

Perhaps you could try to use the first option, use WebInput control, like in Yudi’s prior post.

However, if you still want to use the VistaCalendar, I have a work around regarding this VistaCalendar issue.

First, set the “AllowDelete” property to “Yes”. Then add a couple line of code in “OnBeforeDelete” & “OnRowContextMenu” client side event.

In OnBeforeDelete event:

function WebGrid1_OnBeforeDelete(controlId, tblName, rowObject){
    return false;
}

In OnRowContextMenu event:

function WebGrid1_OnRowContextMenu(controlId, rowType, rowElement, menuObject)
{
    var WebGrid1 = ISGetObject(controlId);
    menuObject.Items.GetNamedItem("mnuSep2").Hide();
    menuObject.Items.GetNamedItem("mnuDelete").Hide();
    return true;
}

These codes above to prevent user delete row from WebGrid.

I attached the WebGrid sample regarding this work around. In this sample, I bind WebGrid to AccessDataSource (Northwind.mdb and Employees table).

I apologize for the inconvenience.

Regards,
Hans K.

Problem with filter not tolerent to error in format

aliard@sigma-rh.com — Tue, 17 Jun 2014 16:17:26 GMT

Here is my sample

Problem with filter not tolerent to error in format

aliard@sigma-rh.com — Tue, 17 Jun 2014 16:16:22 GMT

Hi Yudi,

I tried using VistaCalendar, it works only if I leave AllowEdit to true; In my case, I must leave it at false.

When AllowEdit is false and I try to open the calendar, it crashes on a null exption in VistaCalendar.js trying to access this.Grid.CultureInfo which is null.

Regards,

Alex

Problem with filter not tolerent to error in format

yudi — Tue, 17 Jun 2014 05:58:11 GMT

You can try to use WebInput with pre-defined format and mask expression, for example:

<ISWebInput:WebInput ID="WebInput1" runat="server">    <HighLight IsEnabled="True" Type="Phrase" />
    <CultureInfo CultureName="en-US">
    </CultureInfo>
    <EditFormat Format="MM/dd/yyyy" IsEnabled="True">
        <MaskInfo MaskExpression="00/00/0000">
        </MaskInfo>
        <ErrorWindowInfo IsEnabled="True">
        </ErrorWindowInfo>
    </EditFormat>
</ISWebInput:WebInput>

And use it as WebGrid's FilterEditType.

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" ..>
    <RootTable DataKeyField="OrderID">
        <Columns>
            ...
            <ISWebGrid:WebGridColumn Caption="OrderDate" DataMember="OrderDate"
                DataType="System.DateTime" Name="OrderDate" EditType="Custom"
                CustomEditorName="WebInputNET" CustomEditorServerId="WebInput1"
                Width="100px" FilterEditType="SameAsEditType">
            </ISWebGrid:WebGridColumn>
            ...
        </Columns>
    </RootTable>
    <LayoutSettings AllowEdit="Yes" AllowFilter="Yes" FilterBarVisible="True">
    </LayoutSettings>
</ISWebGrid:WebGrid>

WebGrid sample: IntegrationwithWebInput.NET.aspx uses WebInput as WebGrid's EditType. With a minor modification, set FilterEditType to SameAsEditType, we can have same experience on the filter bar.

WebGrid also has calendar editor that resembles Vista's calendar styles and behaviors. Fully integrated with WebCalendar API, you can take advantage many of the powerful calendar features, such as multiple months calendar, show week numbers, easy month and year navigation and much more.

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" ...>
    <RootTable Caption="Assets" DataKeyField="AssetID" DataMember="Assets">
        <Columns>
            ...
            <ISWebGrid:WebGridColumn Caption="Date Acquired" DataMember="DateAcquired" DataType="System.DateTime"
                Name="DateAcquired" Width="100px" CustomEditorName="VistaCalendar"
                CustomEditorProperties="IsReadOnly=true" DataFormatString="d" EditType="Custom"
                FilterEditType="SameAsEditType">
            </ISWebGrid:WebGridColumn>
            ...
        </Columns>
    </RootTable>
</ISWebGrid:WebGrid>

Using the above settings, will avoid user for mistakenly input incorrect date format (since IsReadOnly is enabled in CustomEditorProperties).

Another thing to try is to inform user about the desired date time format by utilizing the verbose information text in editing mode. This feature is useful to deliver intuitive editing experience for users as they can notice on important information related to a specific column in status bar area. It also allows you to assign information text and image for each WebGridColumn.

In order to use this feature, we need to enable VerboseEditingInformation property (WebGrid\LayoutSettings\VerboseEditingInformation) and assign EditInfoText and/or EditInfoImage on each WebGridColumn.

CustomEditor_VistaCalendar.aspx sample of WebGrid shows the usage of VistaCalendar custom editor and simple EditInfoText in one place.

Please have the samples evaluated on your end and let us know whether it helps or not.

Problem with filter not tolerent to error in format

aliard@sigma-rh.com — Mon, 16 Jun 2014 13:18:57 GMT

Hi Hans,

We tried CalendarCombo, but it still allows the user to enter a date manually and to possibly crash if the format is not valid.

We did not find CalendarDropdown in the options. Are you sure it is available?

Do you know if it is possible to use our own control and then bypass this error by managing it by ourselves ?

Regards,

Alex

Problem with filter not tolerent to error in format

Hans — Mon, 16 Jun 2014 00:07:59 GMT

Hello,

Perhaps you could modify the column’s “EditType” property to “CalendarDropdown” or “CalendarCombo”.
So user can select the date from the Calendar, without having to know the date format.

Here’s example snippet code how to set the EditType property:

<ISWebGrid:WebGridColumn Caption="Date Column" DataMember="" Name="date_column"    Width="150px" EditType="CalendarDropdown" DataType="System.Datetime" DataFormatString="yyyy-MM-dd"
    EditInfoText="Select Date from Calendar">
</ISWebGrid:WebGridColumn>

Hope this helps.

Regards,
Hans K.

Problem with filter not tolerent to error in format

aliard@sigma-rh.com — Fri, 13 Jun 2014 09:33:10 GMT

Actually, we cannot use filter on dates because the users needs to know exactly how to type the date. I.E. if a user mistype a date in the filter, they will have an exception. See file attached,.

Can you fix this bug?