Intersoft Community - WebGrid Enterprise - Filtering with localized datetime columns throws error

Filtering with localized datetime columns throws error

handy@intersoftpt.com — Mon, 26 Oct 2009 04:22:17 GMT

The issue has been fixed. The hotfix would be released at the short time (today or tomorrow).

Regards,
Handy

Filtering with localized datetime columns throws error

info@zeppelin-it.com — Mon, 26 Oct 2009 03:01:03 GMT

Could you please give me an update on the status of this bug. Or otherwise, is there a workaround?

Thanks,
Stefan

Filtering with localized datetime columns throws error

handy@intersoftpt.com — Thu, 15 Oct 2009 05:32:37 GMT

I am sorry that I am late to response you. I have worked on some test and yes, as you said. The issue still appeared when used Italian. I have reported back to our developer team. I will let you know in a short time.

Regards,
Handy

Filtering with localized datetime columns throws error

info@zeppelin-it.com — Fri, 09 Oct 2009 02:15:54 GMT

yes, I updated also the Web.UI assemblies, running them with local copy in bin.

Filtering with localized datetime columns throws error

handy@intersoftpt.com — Thu, 08 Oct 2009 23:47:25 GMT

Hello,

Have you also applied Framework update? Please also ensure that in your project bin folder, all the assemblies are the latest.

Regards,
Handy

Filtering with localized datetime columns throws error

info@zeppelin-it.com — Thu, 08 Oct 2009 04:18:44 GMT

I'm afraid that the bug hasn't been fixed completely with 6.0.7200.217. It works only using English as Webgrid-Culture. Here a little table:

Webgrid-Language .216 .217

English error okay

German okay okay

Italian error error

Filtering with localized datetime columns throws error

handy@intersoftpt.com — Wed, 07 Oct 2009 23:29:21 GMT

Yes, we have release new hotfix yesterday. You can try to update it via UpdateManager.

Filtering with localized datetime columns throws error

info@zeppelin-it.com — Wed, 07 Oct 2009 11:41:22 GMT

Is there a fix yet?

Filtering with localized datetime columns throws error

technical@intersoftpt.com — Fri, 18 Sep 2009 23:33:56 GMT

Stefan, this issue has been fixed, and the fix will be available in this month's hotfix due sometime next week. Thanks.

Filtering with localized datetime columns throws error

info@zeppelin-it.com — Fri, 18 Sep 2009 02:17:51 GMT

Any news? This is very important to me.

Thanks,

Stefan

Filtering with localized datetime columns throws error

info@zeppelin-it.com — Wed, 09 Sep 2009 02:43:32 GMT

I'm using the latest Webgrid/WebUI version and noticed an error on filtering columns with localized datetime columns (when I apply the filter - flypostback). The WebgridRow:

iswebgrid:WebGridColumn DataFormatString="d" DataType="System.DateTime" Caption="Creation date" DataMember="dtCreate" EditType="NoEdit" Name="dtCreate" FilterEditType="CalendarCombo" Width="70px" Visible="True"

This bug must have been introduced in .215 I think, it worked until recently.

The error stack is:
String was not recognized as a valid DateTime.
[FormatException: String was not recognized as a valid DateTime.]
   System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) 4582898
   System.Data.ConstNode..ctor(DataTable table, ValueType type, Object constant, Boolean fParseQuotes) 557
   System.Data.ConstNode..ctor(DataTable table, ValueType type, Object constant) 14
   System.Data.ExpressionParser.Parse() 1032
   System.Data.DataExpression..ctor(DataTable table, String expression, Type type) 154
   System.Data.DataView.set_RowFilter(String value) 188
   ISNet.WebUI.WebGrid.DataBinding.??(WebGrid grid, WebGridTable table, DataView dataSource) 3029
   ISNet.WebUI.WebGrid.DataBinding. (DataView dataSource, String dataMember, String request) 688
   ISNet.WebUI.ISNetControl.ControlRequestHandler(Object sender, EventArgs e) 426

[Exception: String was not recognized as a valid DateTime.]
   ISNet.WebUI.ISNetControl.ControlRequestHandler(Object sender, EventArgs e) 789
   System.EventHandler.Invoke(Object sender, EventArgs e) 0
   System.Web.UI.Control.OnPreRender(EventArgs e) 11022094
   System.Web.UI.Control.PreRenderRecursiveInternal() 108
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 3394