This is a migrated thread and some comments may be shown as answers.

Filtering Time and DateTime issue

6 Answers 261 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Vik asked on 07 Aug 2008, 05:14 PM

Hi all,

I have a grid and three datetime columns within it.
<telerik:GridDateTimeColumn PickerType="DatePicker" DataType="System.DateTime" ...
<telerik:GridDateTimeColumn PickerType="DateTimePicker" DataType="System.DateTime" ...
<telerik:GridDateTimeColumn PickerType="TimePicker" DataType="System.DateTime" ...

Filtering by using DatePicker works fine.
When I try to filter by second column where I get to choose date and time (from DateTimePicker) and by 3rd column I get to choose time (from TimePicker) I get following error:

The string was not recognized as a valid DateTime.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: The string was not recognized as a valid DateTime.

Source Error:


            An unhandled exception was generated during the execution of the
            current web request. Information regarding the origin and location of
            the exception can be identified using the exception stack trace below.

Stack Trace:

[FormatException: The string was not recognized as a valid DateTime.]

            Telerik.Web.UI.RadDatePicker.set_DbSelectedDate(Object value) +607

            Telerik.Web.UI.GridDateTimeColumnHelper.SetDataInputControlValue(Control control, GridDateTimeColumnPickerType pickerType, String value) +51

            Telerik.Web.UI.GridDateTimeColumn.SetCurrentFilterValueToControl(TableCell cell) +103

            Telerik.Web.UI.GridColumn.SetCurrentFilterValueToControlInternal(TableCell cell) +31

            Telerik.Web.UI.RadGrid.RaisePostBackEvent(String eventArgument) +7375

            System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11

            System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177

            System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

Any ideas?

Another question: Is it possible to set up grid not to display or localize javascript alert "No filter value!" when filter value is empty?

Thanks a lot for the answers.
Vik

6 Answers, 1 is accepted

answered on 12 Aug 2008, 05:52 AM

Prometheus_Test.zip

Hello Vik,

I tested the behavior that you mentioned, and the control behaved as expected. Attached to this message, is the code, which I used for testing. Take a look at it and let me know if this is the expected behavior, or I am leaving something out.
Additionally, at present there is no option to remove/customize the alert which you mentioned. I will pass this as a feature suggestion to our dev team.

Greetings,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

answered on 25 Aug 2008, 08:13 AM

Hello andy,

Unfortunatly this is not supported out of the box but you can easly accomplish the desired behavior by hooking to RadGrid's OnColumnResizing client event, then get the resized column's resizer object and change it tooltip text, similar to this:

    
            function onColumnResizing(sender,args)  
        
            {  
        
                var resizerToolTip = args.get_gridColumn()._columnResizer._resizerToolTip;  
        
                     resizerToolTip.innerHTML = resizerToolTip.innerHTML.replace("Width:","test");    
        
            }

Kind regards,

Rosen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.