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,
Can you tell me what version of our controls do you use and what is the build version of these controls?
Thank you.
We use NetAdvantage 2011 V1 and the exact Version of Infragistics4.Web.v11.1 is: 11.1.20111.1006
I have VS 2010 Ultimate on Win7.
Hi
i am new to webdatagrid
i use NetAdvantage 2011 V1(Infragistics4.Web.v11.1)
"could you kindly give me a sample for editing values in webdatagrid.?"
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.
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.