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!!