Marc-Andre
Top achievements
Rank 1
Marc-Andre
asked on 04 Jan 2011, 02:58 PM
Hi, I'm having issue with save/load layout of a grid control.
I have a date column that I filter between date 1 and date 2. If I save the layout I cannot reload it. I get an error message in Visual Studio :
Exception has been thrown by the target of an invocation.
{"Invalid filter expression."}
I noticed that the filter menu changed since last version and I can now select dates with a calendar control instead of a textbox. Maybe it has something to do with it...
thanks
I have a date column that I filter between date 1 and date 2. If I save the layout I cannot reload it. I get an error message in Visual Studio :
Exception has been thrown by the target of an invocation.
{"Invalid filter expression."}
I noticed that the filter menu changed since last version and I can now select dates with a calendar control instead of a textbox. Maybe it has something to do with it...
thanks
28 Answers, 1 is accepted
0
Richard Slade
Top achievements
Rank 2
answered on 04 Jan 2011, 03:09 PM
Hello,
Perhaps you can post a sample. I know that whenever we upgrade to a new version of the controls, we delete all of the saved layout files as changes in the grid often make older ones incompatible with the newer versions. I'd first try deleting all of your saved layout files and then firing up the app and saving and loading the layout again.
regards,
Richard
Perhaps you can post a sample. I know that whenever we upgrade to a new version of the controls, we delete all of the saved layout files as changes in the grid often make older ones incompatible with the newer versions. I'd first try deleting all of your saved layout files and then firing up the app and saving and loading the layout again.
regards,
Richard
0
Marc-Andre
Top achievements
Rank 1
answered on 04 Jan 2011, 03:28 PM
Hi Richard, thanks for your quick response.
I tried deleting the old layout. I works fine until you set a range of date again. I have a complex project so it's hard to post a sample but I guess it can be reproduced by doing these steps :
1- Apply filter in a date column by choosing Between.
2- Leave default settings (change dates) and confirm
3- Save layout
4- Close the form
5- Open the form and load the layout
Let me know if I can provide further details
thanks a lot
I tried deleting the old layout. I works fine until you set a range of date again. I have a complex project so it's hard to post a sample but I guess it can be reproduced by doing these steps :
1- Apply filter in a date column by choosing Between.
2- Leave default settings (change dates) and confirm
3- Save layout
4- Close the form
5- Open the form and load the layout
Let me know if I can provide further details
thanks a lot
0
Marc-Andre
Top achievements
Rank 1
answered on 04 Jan 2011, 03:33 PM
Hey again, I have other information.
I tried to filter using Between again, but this time I didn't change the dates, left them as is. I got no problem. So it seems that it happens if you change the dates.
The other thing I noticed, today on my computer is 04-01-2011 which is January 4th 2011. When I do that in the filter section and I save the layout and load it back, it shows 01-04-2011 which is April 1st 2011. I'm not sure what I can do about that?
Thanks a lot
I tried to filter using Between again, but this time I didn't change the dates, left them as is. I got no problem. So it seems that it happens if you change the dates.
The other thing I noticed, today on my computer is 04-01-2011 which is January 4th 2011. When I do that in the filter section and I save the layout and load it back, it shows 01-04-2011 which is April 1st 2011. I'm not sure what I can do about that?
Thanks a lot
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 04 Jan 2011, 03:48 PM
Hello Marc André
I can reproduce a similar bug here with my app (2010Q3). When I load a layout with a Between Filter on a Date Column.
Telerik.WinControls.Data.FilterExpressionException: Invalid filter expression. ---> Telerik.Data.Expressions.InvalidExpressionException: Cannot perform '>=' operation on System.DateTime and System.String.
at Telerik.Data.Expressions.Operator.BinaryCompare(Object value1, Object value2, StorageType resultType, Operator op, IFormatProvider formatProvider)
at Telerik.Data.Expressions.Operator.GreaterOrEqualFunc(Operand lhs, Operand rhs, OperatorContext context)
at Telerik.Data.Expressions.BinaryOpNode.Eval(Object row, Object context)
at Telerik.Data.Expressions.Operand.get_Value()
at Telerik.Data.Expressions.Operator.AndFunc(Operand lhs, Operand rhs, OperatorContext context)
at Telerik.Data.Expressions.BinaryOpNode.Eval(Object row, Object context)
at Telerik.Data.Expressions.Operand.get_Value()
at Telerik.Data.Expressions.Operator.RValueFunc(Operand rhs, OperatorContext context)
at Telerik.Data.Expressions.UnaryOpNode.Eval(Object row, Object context)
at Telerik.WinControls.Data.RadCollectionView`1.PerformExpressionFilter(TDataItem item)
--- End of inner exception stack trace ---
at Telerik.WinControls.Data.RadCollectionView`1.PerformExpressionFilter(TDataItem item)
at Telerik.WinControls.Data.RadCollectionView`1.PassesFilter(TDataItem item)
at Telerik.WinControls.Data.AvlIndex`1.Perform()
at Telerik.WinControls.Data.AvlIndex`1.get_Items()
at Telerik.WinControls.Data.RadDataView`1.get_Items()
at Telerik.WinControls.Data.RadCollectionView`1.get_Count()
at Telerik.WinControls.Data.RadCollectionView`1.get_CurrentItem()
at Telerik.WinControls.Data.RadDataView`1.RebuildData(Boolean notify)
at Telerik.WinControls.Data.RadDataView`1.RefreshOverride()
at Telerik.WinControls.Data.RadDataView`1.ProcessCollectionChanged(NotifyCollectionChangedEventArgs args)
at Telerik.WinControls.Data.RadCollectionView`1.source_CollectionChanged(Object sender, NotifyCollectionChangedEventArgs e)
at Telerik.WinControls.Data.NotifyCollectionChangedEventHandler.Invoke(Object sender, NotifyCollectionChangedEventArgs e)
at Telerik.WinControls.Data.RadListSource`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
at Telerik.WinControls.Data.RadListSource`1.EndUpdate(Boolean notifyUpdates)
at Telerik.WinControls.UI.GridViewTemplate.EndUpdate(Boolean notify, DataViewChangedEventArgs e)
at Telerik.WinControls.UI.MasterGridViewTemplate.EndUpdate(Boolean notify, DataViewChangedEventArgs e)
at Telerik.WinControls.UI.GridViewTemplate.EndUpdate()
at Telerik.WinControls.UI.RadGridView.LoadLayout(XmlReader xmlReader)
at Telerik.WinControls.UI.RadGridView.LoadLayout(String fileName)
at puttymgr.Controls.QueryViewUserControl.Initialize()
at puttymgr.MainForm.n1spsPage_HandleCreated(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3615 (GDR.050727-3600)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
puttymgr
Assembly Version: 2.1.4003.23680
Win32 Version: 2.1.0.0
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/puttymgr.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Telerik.WinControls.UI
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.UI.DLL
----------------------------------------
Telerik.WinControls
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
TelerikCommon
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/TelerikCommon.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
y6thyy47
Assembly Version: 2010.3.10.1109
Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Telerik.WinControls.GridView
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.GridView.DLL
----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.DirectoryServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
Npgsql
Assembly Version: 2.0.11.0
Win32 Version: 2.0.11.0
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Npgsql.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Mono.Security.DLL
----------------------------------------
I can reproduce a similar bug here with my app (2010Q3). When I load a layout with a Between Filter on a Date Column.
Telerik.WinControls.Data.FilterExpressionException: Invalid filter expression. ---> Telerik.Data.Expressions.InvalidExpressionException: Cannot perform '>=' operation on System.DateTime and System.String.
at Telerik.Data.Expressions.Operator.BinaryCompare(Object value1, Object value2, StorageType resultType, Operator op, IFormatProvider formatProvider)
at Telerik.Data.Expressions.Operator.GreaterOrEqualFunc(Operand lhs, Operand rhs, OperatorContext context)
at Telerik.Data.Expressions.BinaryOpNode.Eval(Object row, Object context)
at Telerik.Data.Expressions.Operand.get_Value()
at Telerik.Data.Expressions.Operator.AndFunc(Operand lhs, Operand rhs, OperatorContext context)
at Telerik.Data.Expressions.BinaryOpNode.Eval(Object row, Object context)
at Telerik.Data.Expressions.Operand.get_Value()
at Telerik.Data.Expressions.Operator.RValueFunc(Operand rhs, OperatorContext context)
at Telerik.Data.Expressions.UnaryOpNode.Eval(Object row, Object context)
at Telerik.WinControls.Data.RadCollectionView`1.PerformExpressionFilter(TDataItem item)
--- End of inner exception stack trace ---
at Telerik.WinControls.Data.RadCollectionView`1.PerformExpressionFilter(TDataItem item)
at Telerik.WinControls.Data.RadCollectionView`1.PassesFilter(TDataItem item)
at Telerik.WinControls.Data.AvlIndex`1.Perform()
at Telerik.WinControls.Data.AvlIndex`1.get_Items()
at Telerik.WinControls.Data.RadDataView`1.get_Items()
at Telerik.WinControls.Data.RadCollectionView`1.get_Count()
at Telerik.WinControls.Data.RadCollectionView`1.get_CurrentItem()
at Telerik.WinControls.Data.RadDataView`1.RebuildData(Boolean notify)
at Telerik.WinControls.Data.RadDataView`1.RefreshOverride()
at Telerik.WinControls.Data.RadDataView`1.ProcessCollectionChanged(NotifyCollectionChangedEventArgs args)
at Telerik.WinControls.Data.RadCollectionView`1.source_CollectionChanged(Object sender, NotifyCollectionChangedEventArgs e)
at Telerik.WinControls.Data.NotifyCollectionChangedEventHandler.Invoke(Object sender, NotifyCollectionChangedEventArgs e)
at Telerik.WinControls.Data.RadListSource`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
at Telerik.WinControls.Data.RadListSource`1.EndUpdate(Boolean notifyUpdates)
at Telerik.WinControls.UI.GridViewTemplate.EndUpdate(Boolean notify, DataViewChangedEventArgs e)
at Telerik.WinControls.UI.MasterGridViewTemplate.EndUpdate(Boolean notify, DataViewChangedEventArgs e)
at Telerik.WinControls.UI.GridViewTemplate.EndUpdate()
at Telerik.WinControls.UI.RadGridView.LoadLayout(XmlReader xmlReader)
at Telerik.WinControls.UI.RadGridView.LoadLayout(String fileName)
at puttymgr.Controls.QueryViewUserControl.Initialize()
at puttymgr.MainForm.n1spsPage_HandleCreated(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnHandleCreated(EventArgs e)
at System.Windows.Forms.Control.WmCreate(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3615 (GDR.050727-3600)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
puttymgr
Assembly Version: 2.1.4003.23680
Win32 Version: 2.1.0.0
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/puttymgr.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Telerik.WinControls.UI
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.UI.DLL
----------------------------------------
Telerik.WinControls
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
TelerikCommon
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/TelerikCommon.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
y6thyy47
Assembly Version: 2010.3.10.1109
Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Telerik.WinControls.GridView
Assembly Version: 2010.3.10.1109
Win32 Version: 2010.3.10.1109
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Telerik.WinControls.GridView.DLL
----------------------------------------
System.Core
Assembly Version: 3.5.0.0
Win32 Version: 3.5.30729.1 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.DirectoryServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
Npgsql
Assembly Version: 2.0.11.0
Win32 Version: 2.0.11.0
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Npgsql.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Program%20Files/RTC/RTC%20UAM%20PuTTY%20Manager%202.0/Mono.Security.DLL
----------------------------------------
0
Marc-Andre
Top achievements
Rank 1
answered on 04 Jan 2011, 03:55 PM
forgot to mention that I'm using Q3 2010 SP1
0
Richard Slade
Top achievements
Rank 2
answered on 04 Jan 2011, 04:07 PM
Hello,
I can confirm I can also replicate it on our system. I set a between filter on a date column and save the layout. Re-load and have the error stack as shown by Erwin. Telerik admins are quick to read these forum posts, so hopefully this will be fixed in the next release.
Richard
I can confirm I can also replicate it on our system. I set a between filter on a date column and save the layout. Re-load and have the error stack as shown by Erwin. Telerik admins are quick to read these forum posts, so hopefully this will be fixed in the next release.
Richard
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 04 Jan 2011, 04:07 PM
OK, have narrowed it down further:
Seems to be connected to the locale setting of the computer. In European Countries, when loading the date, day and month are exchanged. If there is still a valid date, no problem (for example 01-05-2010 / 05-01-2010 will just give unexpected results, but no exception, 12-31-2010 / 31-12-2010 however will throw an exception.
Also I guess that with a less or equal filter on a date/time, the time value should be 23:59:59 not 00:00:00.
Another bug I have noticed is that the between filter dialog does not keep its previous values.
Regards
Erwin
Seems to be connected to the locale setting of the computer. In European Countries, when loading the date, day and month are exchanged. If there is still a valid date, no problem (for example 01-05-2010 / 05-01-2010 will just give unexpected results, but no exception, 12-31-2010 / 31-12-2010 however will throw an exception.
Also I guess that with a less or equal filter on a date/time, the time value should be 23:59:59 not 00:00:00.
Another bug I have noticed is that the between filter dialog does not keep its previous values.
Regards
Erwin
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 04 Jan 2011, 04:12 PM
I would suggest that the layout should persist date/time values using an XML standard format such as
2002-05-30T09:00:00
and not something that depends on the current locale settings.
2002-05-30T09:00:00
and not something that depends on the current locale settings.
0
Marc-Andre
Top achievements
Rank 1
answered on 04 Jan 2011, 04:25 PM
Any suggestion in a way to work around this?
thanks for your efforts guys
thanks for your efforts guys
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 04 Jan 2011, 04:36 PM
CultureInfo currentCulture = Thread.CurrentThread.CurrentCulture;
CultureInfo currentUICulture = Thread.CurrentThread.CurrentUICulture;
try
{
Thread.CurrentThread.CurrentCulture=
new
CultureInfo(
"en-US"
);
Thread.CurrentThread.CurrentUICulture=
new
CultureInfo(
"en-US"
);
gridView.LoadLayout(GetLayoutPath());
}
finally
{
Thread.CurrentThread.CurrentCulture=currentCulture;
Thread.CurrentThread.CurrentUICulture=currentUICulture;
}
Maybe fiddling around with the locales before save / load of layout could help until the bug is fixed.
Make sure to restore to the previous values afterwards.
However, IMHO best solution is to wait for the bugfix release from Telerik. At least my user base seems not to use complex filters like this much, otherwise I would have got a bug report since the 2010Q3 based release (Mid November 2010).
Regards
Erwin
0
Richard Slade
Top achievements
Rank 2
answered on 04 Jan 2011, 04:47 PM
Hi,
Yes, it does seem to be fine as you've suggested Erwin just by setting the
We have to keep our dates in en-GB format but like you, our users don't implement complex filters.
@Marc-Andre - as Erwin suggested, I think this may be the only useable option for the time being.
Regards,
Richard
Yes, it does seem to be fine as you've suggested Erwin just by setting the
Thread.CurrentThread.CurrentCulture =
new
CultureInfo(
"en-US"
);
We have to keep our dates in en-GB format but like you, our users don't implement complex filters.
@Marc-Andre - as Erwin suggested, I think this may be the only useable option for the time being.
Regards,
Richard
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 04 Jan 2011, 04:51 PM
Be aware though that this may lead to other problems if locale dependent formatting is used on the values of any other filter in the grid.
IMHO the persistence format for load layout / save layout should be absolutely neutral to locale settings. Think of layout files that are used on a computer with a different locale than they were generated.
Regards
Erwin
IMHO the persistence format for load layout / save layout should be absolutely neutral to locale settings. Think of layout files that are used on a computer with a different locale than they were generated.
Regards
Erwin
0
Marc-Andre
Top achievements
Rank 1
answered on 04 Jan 2011, 04:53 PM
Thanks for provinding these solutions. I will try your suggestions and let you know.
0
Marc-Andre
Top achievements
Rank 1
answered on 04 Jan 2011, 05:03 PM
Hi guys, I tested the use of different culture before loading the layout and it seems to help preventing the annoying exception. But I still experience an issue when I try to change the filter, it says: String was not recognized as a valid DateTime..
Thanks again for your help
Thanks again for your help
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 05 Jan 2011, 08:11 PM
Hello everybody, I filed a bug report Ticket ID 381468, to keep track on this bug, would like to see it in PITS.
Regards
Erwin
Regards
Erwin
0
Hi guys,
Thank you for investigating the issue in detail. We are aware of it and it will be addressed in one of the next releases. We have logged the issue in our Public Issue Tracking System.
Regards,
Martin Vasilev
the Telerik team
Thank you for investigating the issue in detail. We are aware of it and it will be addressed in one of the next releases. We have logged the issue in our Public Issue Tracking System.
Regards,
Martin Vasilev
the Telerik team
0
Marc-Andre
Top achievements
Rank 1
answered on 02 Mar 2011, 03:15 PM
I would like to add another issue. I think it is related to the same thing. Here's what I did to reproduce the problem.
The grid doesn't show me the correct information, it shows only the values greater than. The thing is, on my computer I do not have the issue. But on some of the client workstations, it does that. My point of view is that the grid's filter is not using the proper date format...
If this can be addressed at the same time it would be great.
Thanks
- Set the date column filter to : greater or equal to
- Select a date from the filter
- The grid shows me correct information.
- Before I save the layout, I remove the filter from the date column otherwise I'm going to get the error message described previously.
- Save the layout.
- Close the form and reopen it.
- Load grid's layout.
- Set the column filter to : greater or equal to
- Select a date from the filter
The grid doesn't show me the correct information, it shows only the values greater than. The thing is, on my computer I do not have the issue. But on some of the client workstations, it does that. My point of view is that the grid's filter is not using the proper date format...
If this can be addressed at the same time it would be great.
Thanks
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 03 Mar 2011, 09:32 AM
Hi,
Just a thought - sometimes had issues like this (in my own code, not with the grid so far) if the datetime/timestamp resolution was not exactly the same.
For example internal resolution in the database is in milliseconds and the value you store/compare to has just seconds. You will not find an exact match unless you are really lucky (1:1000)
Regards
Erwin
Just a thought - sometimes had issues like this (in my own code, not with the grid so far) if the datetime/timestamp resolution was not exactly the same.
For example internal resolution in the database is in milliseconds and the value you store/compare to has just seconds. You will not find an exact match unless you are really lucky (1:1000)
Regards
Erwin
0
Marc-Andre
Top achievements
Rank 1
answered on 03 Mar 2011, 03:11 PM
Thanks Erwin.. I wish it just that.. but the behavior is always the same if I repeat these steps and it differs from one PC to another depending on the locale.. there's got to be something wrong in the save layout procedure.
thanks
thanks
0
Hi folks,
We have made the save/load layout feature culture independent and the change will be available in the upcoming Q1 2011 release. I hope this will resolve the described DateTime filtering issues.
Regards,
Martin Vasilev
the Telerik team
We have made the save/load layout feature culture independent and the change will be available in the upcoming Q1 2011 release. I hope this will resolve the described DateTime filtering issues.
Regards,
Martin Vasilev
the Telerik team
Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
0
erwin
Top achievements
Rank 1
Veteran
Iron
answered on 23 Mar 2011, 12:56 AM
apparently does not work with Q1 2011, still throws invalid filter expression exception.
The filter is still serialized in US American Format MM/DD/YY where a standard with no possibility of confusion should be used such as ISO:
YYYY-MM-DD.
The filter is still serialized in US American Format MM/DD/YY where a standard with no possibility of confusion should be used such as ISO:
YYYY-MM-DD.
<
Telerik.WinControls.Data.CompositeFilterDescriptor
NotOperator
=
"False"
PropertyName
=
"LastScan"
IsFilterEditor
=
"True"
>
<
FilterDescriptors
>
<
Telerik.WinControls.Data.FilterDescriptor
PropertyName
=
"LastScan"
Operator
=
"IsGreaterThanOrEqualTo"
Value
=
"10/05/2010 00:00:00"
/>
<
Telerik.WinControls.Data.FilterDescriptor
PropertyName
=
"LastScan"
Operator
=
"IsLessThanOrEqualTo"
Value
=
"03/22/2011 00:00:00"
/>
</
FilterDescriptors
>
</
Telerik.WinControls.Data.CompositeFilterDescriptor
>
</
FilterDescriptors
>
0
Hi erwin,
Thank you for contacting us.
Although we have changed the save/load layout to work only with invariant culture, we have still missed some specific scenarios, which leads to described exception. The fix for them will be available in Q1 2011 Service Pack 1 release.
Write me back if you have any other questions.
All the best,
Martin Vasilev
the Telerik team
Thank you for contacting us.
Although we have changed the save/load layout to work only with invariant culture, we have still missed some specific scenarios, which leads to described exception. The fix for them will be available in Q1 2011 Service Pack 1 release.
Write me back if you have any other questions.
All the best,
Martin Vasilev
the Telerik team
0
John
Top achievements
Rank 1
answered on 20 May 2013, 07:30 AM
Hi,
I am getting a similar issue using version 2012.3.1211.40 wherby dates used in the between filter are being saved in an American format. This then gives rise to the error below when trying to perform a LoadLayout.
"String was not recognized as a valid DateTime"
thanks,
John.
I am getting a similar issue using version 2012.3.1211.40 wherby dates used in the between filter are being saved in an American format. This then gives rise to the error below when trying to perform a LoadLayout.
"String was not recognized as a valid DateTime"
thanks,
John.
0
Hello John,
Thank you for reporting this issue.
This is a regression one and I am reopening the case. Is it possible to send us the problematic XML file? This will allow us to make sure that your case is covered.
Note that you have to open a new support ticket in order to be able to attach your file.
Regards,
Peter
Telerik
Thank you for reporting this issue.
This is a regression one and I am reopening the case. Is it possible to send us the problematic XML file? This will allow us to make sure that your case is covered.
Note that you have to open a new support ticket in order to be able to attach your file.
Regards,
Peter
Telerik
RadChart for WinForms is obsolete. Now what?
0
John
Top achievements
Rank 1
answered on 24 May 2013, 11:39 AM
Hi Peter
The first xml is saving a between dates filter for 24th May 2013. You can see the format is American (mm/dd/yyyy). The second xml is saving an equals date filter and the format is correct, UK (dd/mm/yyyy).
Hope this helps,
Thanks,
John.
The first xml is saving a between dates filter for 24th May 2013. You can see the format is American (mm/dd/yyyy). The second xml is saving an equals date filter and the format is correct, UK (dd/mm/yyyy).
Hope this helps,
Thanks,
John.
<
RadGridView
AutoSizeRows
=
"True"
ShowCellErrors
=
"False"
ShowRowErrors
=
"False"
ReadOnly
=
"True"
BackColor
=
"Window"
Cursor
=
"Default"
TabIndex
=
"2"
>
<
MasterTemplate
EnableAlternatingRowColor
=
"True"
AllowDeleteRow
=
"False"
AllowAddNewRow
=
"False"
EnableFiltering
=
"True"
AutoSizeColumnsMode
=
"Fill"
AutoGenerateColumns
=
"False"
ShowRowHeaderColumn
=
"False"
>
<
Columns
>
<
Telerik.WinControls.UI.GridViewDateTimeColumn
Width
=
"88"
Name
=
"columnDate"
SortOrder
=
"Descending"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Date"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
>
<
FilterDescriptor
xsi:type
=
"Telerik.WinControls.Data.CompositeFilterDescriptor"
NotOperator
=
"False"
PropertyName
=
"columnDate"
IsFilterEditor
=
"True"
xmlns:xsi
=
"http://www.w3.org/2001/XMLSchema-instance"
>
<
FilterDescriptors
>
<
Telerik.WinControls.Data.FilterDescriptor
PropertyName
=
"columnDate"
Operator
=
"IsGreaterThanOrEqualTo"
Value
=
"05/24/2013 00:00:00"
/>
<
Telerik.WinControls.Data.FilterDescriptor
PropertyName
=
"columnDate"
Operator
=
"IsLessThanOrEqualTo"
Value
=
"05/24/2013 00:00:00"
/>
</
FilterDescriptors
>
</
FilterDescriptor
>
</
Telerik.WinControls.UI.GridViewDateTimeColumn
>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"215"
Name
=
"columnChanged"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Updated By"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"424"
Name
=
"columnEvent"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Event"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"183"
Name
=
"columnCRN"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"CRN"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"165"
Name
=
"columnVersionNo"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Version Number"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"68"
Name
=
"columnFormDefType"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Type"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"113"
Name
=
"columnFormDefGroup"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Form Definition Group / Form Type"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"53"
Name
=
"columnSignOffStatus"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Status"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewCheckBoxColumn
Width
=
"85"
Name
=
"columnInclude"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Chronology"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
</
Columns
>
<
FilterDescriptors
>
<
Telerik.WinControls.Data.CompositeFilterDescriptor
NotOperator
=
"False"
PropertyName
=
"columnDate"
IsFilterEditor
=
"True"
>
<
FilterDescriptors
>
<
Telerik.WinControls.Data.FilterDescriptor
PropertyName
=
"columnDate"
Operator
=
"IsGreaterThanOrEqualTo"
Value
=
"05/24/2013 00:00:00"
/>
<
Telerik.WinControls.Data.FilterDescriptor
PropertyName
=
"columnDate"
Operator
=
"IsLessThanOrEqualTo"
Value
=
"05/24/2013 00:00:00"
/>
</
FilterDescriptors
>
</
Telerik.WinControls.Data.CompositeFilterDescriptor
>
</
FilterDescriptors
>
<
SortDescriptors
>
<
Telerik.WinControls.Data.SortDescriptor
PropertyName
=
"columnDate"
Direction
=
"Descending"
/>
</
SortDescriptors
>
</
MasterTemplate
>
</
RadGridView
>
<
RadGridView
AutoSizeRows
=
"True"
ShowCellErrors
=
"False"
ShowRowErrors
=
"False"
ReadOnly
=
"True"
CausesValidation
=
"False"
BackColor
=
"Window"
Cursor
=
"Default"
TabIndex
=
"2"
>
<
MasterTemplate
EnableAlternatingRowColor
=
"True"
AllowDeleteRow
=
"False"
AllowAddNewRow
=
"False"
EnableFiltering
=
"True"
AutoSizeColumnsMode
=
"Fill"
AutoGenerateColumns
=
"False"
ShowRowHeaderColumn
=
"False"
>
<
Columns
>
<
Telerik.WinControls.UI.GridViewDateTimeColumn
Width
=
"88"
Name
=
"columnDate"
SortOrder
=
"Descending"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Date"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
>
<
FilterDescriptor
xsi:type
=
"Telerik.WinControls.Data.DateFilterDescriptor"
Value
=
"2013-05-24"
IgnoreTimePart
=
"False"
PropertyName
=
"columnDate"
Operator
=
"IsEqualTo"
IsFilterEditor
=
"True"
xmlns:xsi
=
"http://www.w3.org/2001/XMLSchema-instance"
/>
</
Telerik.WinControls.UI.GridViewDateTimeColumn
>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"215"
Name
=
"columnChanged"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Updated By"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"424"
Name
=
"columnEvent"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Event"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"183"
Name
=
"columnCRN"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"CRN"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"165"
Name
=
"columnVersionNo"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Version Number"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"68"
Name
=
"columnFormDefType"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Type"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"113"
Name
=
"columnFormDefGroup"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Form Definition Group / Form Type"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewTextBoxColumn
Width
=
"53"
Name
=
"columnSignOffStatus"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Status"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
<
Telerik.WinControls.UI.GridViewCheckBoxColumn
Width
=
"85"
Name
=
"columnInclude"
IsVisible
=
"True"
ReadOnly
=
"True"
HeaderText
=
"Chronology"
WrapText
=
"True"
TextAlignment
=
"TopLeft"
/>
</
Columns
>
<
FilterDescriptors
>
<
Telerik.WinControls.Data.DateFilterDescriptor
Value
=
"2013-05-24"
IgnoreTimePart
=
"False"
PropertyName
=
"columnDate"
Operator
=
"IsEqualTo"
IsFilterEditor
=
"True"
/>
</
FilterDescriptors
>
<
SortDescriptors
>
<
Telerik.WinControls.Data.SortDescriptor
PropertyName
=
"columnDate"
Direction
=
"Descending"
/>
</
SortDescriptors
>
</
MasterTemplate
>
</
RadGridView
>
0
Hello John,
Thank you for the provided XML files.
Are these files generated on the same PC? Could you share more details about the PC the files were generated on, like Operating System, Regional Settings, which versions of our controls are installed on these machines?
Regards,
Peter
Telerik
Thank you for the provided XML files.
Are these files generated on the same PC? Could you share more details about the PC the files were generated on, like Operating System, Regional Settings, which versions of our controls are installed on these machines?
Regards,
Peter
Telerik
RadChart for WinForms is obsolete. Now what?
0
John
Top achievements
Rank 1
answered on 30 May 2013, 01:06 PM
Hi Peter,
Yes, same pc. Windows 7. Grid version 2012.3.1211.40. Regional setting English (United Kingdom).
A tester also replicated on windows xp.
thanks,
John.
Yes, same pc. Windows 7. Grid version 2012.3.1211.40. Regional setting English (United Kingdom).
A tester also replicated on windows xp.
thanks,
John.
0
Hello John,
Thank you for the provided details. As I mentioned before I reopened the case and we will address it accordingly in a future release. I hope that the workaround from this forum thread is applicable for your case, until the issue is resolved.
Regards,
Peter
Telerik
Thank you for the provided details. As I mentioned before I reopened the case and we will address it accordingly in a future release. I hope that the workaround from this forum thread is applicable for your case, until the issue is resolved.
Regards,
Peter
Telerik
RadChart for WinForms is obsolete. Now what?