I have a problem with updating data in the grid, i checked all the samples and could not find the missing thing to get it to work.
My aspx site is getting a command, this command is getting executed against a sql db with the option to get only the schema. Then i add a empty row to it, and fill the DataKeyFields column with some key.
But when i want to postback the values that the user inserted into to the other columns (than the DataKeyFields column), the web application crashes with following exception:
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.
[FormatException: Input string was not in a correct format.] Infragistics.Web.UI.Framework.Data.DataViewDataSourceAdapter.Update(Object dataItem, IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +1398 Infragistics.Web.UI.Framework.Data.DataSourceObjectView.Update(Object dataItem, IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +62 Infragistics.Web.UI.GridControls.EditingCore.OnAction(String actionType, Object id, Object value, Object tag) +3970 Infragistics.Web.UI.GridControls.GridBehavior.Infragistics.Web.UI.GridControls.IGridBehavior.OnAction(String actionType, Object id, Object value, Object tag) +48 Infragistics.Web.UI.GridControls.GridBot.LoadAdditionalClientState(Object state) +1313 Infragistics.Web.UI.Framework.RunBot.HandleRaisePostDataChangedEvent() +204 Infragistics.Web.UI.GridControls.GridBot.HandleRaisePostDataChangedEvent() +74 Infragistics.Web.UI.Framework.Data.FlatDataBoundControl.RaisePostDataChangedEvent() +37 System.Web.UI.Page.RaiseChangedEvents() +134 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5201What is wrong?
Hello PV85281,
Did you set the column data types to match the ones returned from the Database?
Do you also provide the data to the grid on every Postback?
In order to research this further I will need a working sample that can be run and debugged locally. Isolate your sample and send it to me for further research.
Thank you.
The sample is working again, i had to manually change all version numbers in the web.config and aspx files.
But the same error as before the service release persists.
Any help?
Hi Alexander
I've downloaded and installed the latest service release for ASP.NET. And now i get this error for the WebScriptManager:
ASP.NET runtime error: The base class includes the field 'WebScriptManager1', but its type (Infragistics.Web.UI.WebScriptManager) is not compatible with the type of control (Infragistics.Web.UI.WebScriptManager).
and a similiar one for the WebDataGrid.
ok thanks for these links.
One more thing needed, i want to load the grid when load button was clicked, and want to edit the grid data ?
these samples load the grid in page load event and were editable.
i need to edit the grid after loaded from button click event.
Hello anandraj,
You can use the following online samples as a starting point for grid editing capabilities:
http://samples.infragistics.com/aspnet/Samples/WebDataGrid/Editing-and-Selection/Editing-Editor-Providers/Default.aspx?cn=data-grid&sid=12b48e9e-8ffb-4c61-837c-58118040f669
http://samples.infragistics.com/aspnet/Samples/WebDataGrid/Editing-and-Selection/Editing-Rows-Basic-Features/Default.aspx?cn=data-grid&sid=ec72294d-bd00-4f41-8735-51b6500cb1e9
You can also read the following article from our documentation that explains how to enable and use editing in the grid - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2010.3/CLR4.0/html/WebDataGrid_Enabling_Cell_Editing.html
I hope that this information will be helpful.