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

Entity Datasource AllowAutomaticDeletes=true -> Cannot delete "not a valid value for Decimal"

8 Answers 213 Views

Grid

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

Rich asked on 08 May 2009, 01:40 PM

Hi Allow,

I am using an entity datasource on a grid and allowing auto inserts, updates and deletes. Everything seems to be working fine accept while trying to delete i am getting the following:

Error while setting property 'freightRate': '$222.00 is not a valid value for Decimal.'.

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.Web.UI.WebControls.EntityDataSourceValidationException: Error while setting property 'freightRate': '$222.00 is not a valid value for Decimal.'.

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:


            [EntityDataSourceValidationException: Error while setting property 'freightRate': '$222.00 is not a valid value for Decimal.'.]
   System.Web.UI.WebControls.EntityDataSourceView.ConvertProperties(IDictionary values, PropertyDescriptorCollection propertyDescriptors, ParameterCollection referenceParameters) +71835
   System.Web.UI.WebControls.EntityDataSourceView.ExecuteDelete(IDictionary keys, IDictionary oldValues) +386
   System.Web.UI.DataSourceView.Delete(IDictionary keys, IDictionary oldValues, DataSourceViewOperationCallback callback) +89
   Telerik.Web.UI.GridTableView.PerformDelete(GridEditableItem editedItem, Boolean suppressRebind) +265
   Telerik.Web.UI.GridCommandEventArgs.ExecuteCommand(Object source) +4320
   Telerik.Web.UI.RadGrid.OnBubbleEvent(Object source, EventArgs e) +191
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   Telerik.Web.UI.GridItem.OnBubbleEvent(Object source, EventArgs e) +165
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   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) +1565

I have no code behind (nice) and the column markup looks like:

telerik:GridNumericColumn UniqueName="freightRate" SortExpression="freightRate"

HeaderText="Freight Rate" DataField="freightRate" ColumnEditorID="GridNumericColumnEditor1"

FooterText="Freight Rate" NumericType="Currency" DataType="System.Decimal">

</telerik:GridNumericColumn>

Is it because the NumericType? Should i use a Dataformatstring instead? thanks.

rw

8 Answers, 1 is accepted

answered on 01 Dec 2011, 01:49 AM

Except I have now encountered this with a LinqDataSource. I get the following error:

System.Web.UI.WebControls.

LinqDataSourceValidationException: Failed to set one or more properties on type DataContext.CA_Deals_Items. $249.00 is not a valid value for Decimal.

With GridNumericColumn it fails, whereas with GridTemplateColumn using a RadNumericTextBox, no such issues

<MasterTableView AllowAutomaticDeletes="True"........

<telerik:GridNumericColumn UniqueName="RRP" DataField="RRP" HeaderText="RRP" NumericType="Currency" />

<telerik:GridTemplateColumn UniqueName="RRP" DataField="RRP" HeaderText="RRP">

<ItemTemplate>

<asp:Literal ID="ltlRRP" runat="server" Text='<%#Eval("RRP", "{0:c2}")%>' />

</ItemTemplate>

<EditItemTemplate>

<telerik:RadNumericTextBox ID="tbxRRP" runat="server" DbValue='<%#Bind("RRP")%>' Type="Currency" />

</EditItemTemplate>

</telerik:GridTemplateColumn>

answered on 05 Dec 2011, 10:11 AM

Example.zip

Hi Paul,

I tried to reproduce the described issue but to no avail. I am sending you a simple example please check it out and let me know what differs in your case. Looking forward for your reply.

Regards,
Radoslav
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

answered on 08 Dec 2011, 02:30 PM

Example.zip

Hello Paul,

I still could not reproduce the described issue. I am sending you a modified example which has additional Currency column of type SmallMoney. Also I set Where and an OrderBy clauses to the LinqDataSource and EditMode=”PopUp” to the grid, however everything works as expected. It will be helpful if you send us a small runnable example which demonstrates the described issue. Thus we will be able to gather more details about your scenario, debug the application and investigate the problem.

Looking forward for your reply.

All the best,
Radoslav
the Telerik team