Hello guys,
I get the following error:
Async request failed [ArgumentException]: Object of type 'System.DBNull' cannot be converted to type 'System.String'. at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value) at Infragistics.Web.UI.Framework.Data.DataSourceControlAdapter.<>c__DisplayClass1.<Update>b__0(Int32 affectedRecords, Exception exception) at System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) at Infragistics.Web.UI.Framework.Data.DataSourceControlAdapter.Update(Object dataItem, IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) at Infragistics.Web.UI.Framework.Data.DataSourceObjectView.Update(Object dataItem, IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) at Infragistics.Web.UI.GridControls.EditingCore.OnAction(String actionType, Object id, Object value, Object tag) at Infragistics.Web.UI.GridControls.GridBehavior.Infragistics.Web.UI.GridControls.IGridBehavior.OnAction(String actionType, Object id, Object value, Object tag) at Infragistics.Web.UI.GridControls.GridBot.LoadAdditionalClientState(Object state) at Infragistics.Web.UI.Framework.RunBot.HandleRaisePostDataChangedEvent() at Infragistics.Web.UI.GridControls.GridBot.HandleRaisePostDataChangedEvent() at Infragistics.Web.UI.Framework.Data.FlatDataBoundControl.RaisePostDataChangedEvent() at System.Web.UI.Page.RaiseChangedEvents() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)[HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.lvy_receipt_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\8c245307\29da0fe5\App_Web_gz034ful.1.cs:line 0 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
The editingcore is looking like this:
<Behaviors> <ig:RowEditingTemplate CancelButton="btnCancelTicket" OKButton="btnSaveTicket"> <EditModeActions MouseClick="None" /> <RowEditingClientEvents TemplateClosing="GridRowExitEditMode" /> <ClientBindings> <ig:RowEditingClientBinding ColumnKey="TICKET_CATEGORY" ControlID="txtEditTicketCategory" GetValueJavaScript="$find({ClientID}).get_value()" SetValueJavaScript="$find({ClientID}).set_value({value})" /> <ig:RowEditingClientBinding ColumnKey="LiableCountryCurrency" ControlID="lblEditTicketCurrency" SetValueJavaScript="$get({ClientID}).innerHTML ={value}" /> <ig:RowEditingClientBinding ColumnKey="TICKET_COUNT" ControlID="txtEditTicketCount" GetValueJavaScript="$find({ClientID}).get_value()" SetValueJavaScript="$find({ClientID}).set_value({value})" /> <ig:RowEditingClientBinding ColumnKey="TICKET_PRICE" ControlID="txtEditPriceOfTicket" GetValueJavaScript="$find({ClientID}).get_value()" SetValueJavaScript="$find({ClientID}).set_value({value})" /> </ClientBindings>
So when I enter the edit mode, edit the textboxes and then save, everything is fine.
But as soon as I enter the same row the second time, then edit data, then save, the error appears.
Is there anything I can check or debug to get a hint, where the error appears?
Thanks in advance!
Matthias
Hello Matthias,
I’m just following up to see if you’ve been able to resolve your issue. If you have any questions or concerns or if you need further assistance please let me know.
Best Regards,
Maya Kirova
Developer Support Engineer
Infragistics, Inc.
http://ko.infragistics.com/support
Thank you for posting in our forum.
In order to look into this I’ll need some additional information on the scenario.
Are you using Manual or Auto CRUD and what type of data source are you using for the grid?
It would be helpful if you could provide the whole grid declaration and the databinding and updating logic.
In general you can try handling the server side RowUpdating event. In it you can check in the event arguments what are the values being passed for updating for the row in the e.Values collection. It seems like the exception is being thrown during the updating of a record. Probably some value from the row (e.Values) is null and the grid is trying to save it to a field that doesn’t accept nulls.
I’m looking forward to your reply.
Developer Support Engineer II