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

Possible to filter NumericField?

3 Answers 83 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Derek Hunziker
Top achievements
Rank 1
Derek Hunziker asked on 15 Sep 2008, 01:57 AM
Hello,

I have a standard GridNumericColumn that I would like to filter.  It's set to "Currency" and the DataField is set to a "money" field in my database.

When I filter the column with any number, I get the following result:

The string was not recognized as a valid format.

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 format.

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 format.]
Telerik.Web.UI.RadNumericTextBox.ParseDbValueString(String sValue) +221
Telerik.Web.UI.RadNumericTextBox.set_DbValue(Object value) +844
Telerik.Web.UI.GridNumericColumn.SetCurrentFilterValueToControl(TableCell cell) +121
Telerik.Web.UI.RadGrid.RaisePostBackEvent(String eventArgument) +5748
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1546

Here is the definition in my ASPX page:

<telerik:GridNumericColumn HeaderText="Order Total" DataField="order_total" NumericType="Currency" AllowFiltering="true" SortExpression="order_total" AllowSorting="true" /> 

Is there something I'm missing?

Thanks!!



3 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 15 Sep 2008, 08:17 AM
Hello Derek,

We fixed this and you can contact the support to receive latest Telerik.Web.UI build. I have added 1000 Telerik points to your account.

Best wishes,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Albert Shenker
Top achievements
Rank 1
Veteran
Iron
answered on 16 Jan 2013, 10:11 PM
one of my users has experienced this same error and scenario in the 2012.3.1205.35 controls. Is it possible this bug is back?
0
Angel Petrov
Telerik team
answered on 21 Jan 2013, 12:19 PM
Hello Albert,

I tried reproducing the problem with the version you mentioned but to no avail. You should not experience such kind of behavior as the problem was fixed. However if the issue reproduces please send us a project that we can inspect. In attachments you can find the project which I have tested.

All the best,
Angel Petrov
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Derek Hunziker
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Albert Shenker
Top achievements
Rank 1
Veteran
Iron
Angel Petrov
Telerik team
Share this question
or