I don't know why yet, or how to bind the page..if I remove Data Bind from Page_Load, updating is successful. This means fresh data is retrieved from the database as soon as the page loads. Is Post Back) This way, Data Bind is only called when the page initially loads and leaves your edits alone on postback. Get the data from your database using a sqldatareader and store it in a custom collection by defining your own custom object.
In case you are using an older version of the controls you can check the following feedback item.To cancel the update operation, set the collections, if necessary, before the values are passed to the data source.A common way to use these collections is to HTML-encode the values supplied by the user before they are stored in the data source. The issue was resolved in the R3 2016 SP1 version of the suite. Should you have further questions please do not hesitate to write back.The filter is working ok when the Grid View is loaded, item's are showing or not based on the property 'Is Eco Generated'.