If your data set is getting lost when you click the Update button, make sure that you have code in your page load event so that you only re-create the bound data when you are loading for the first time and not overwriting it on each post back.

Using Code

Use the IsPostBack property.

Example

In this example, the if-endif structure surrounding the DataBind method restricts the method from being run on each post back.

if !(Page.IsPostBack)
    {
        ... other code ...
        FpSpread1.DataBind();
     } 

If Not Page.IsPostBack Then
        ... other code ...
        FpSpread1.DataBind()
End If