I am loading the contents of an Excel file into a dataset and using that dataset as the source for an ultrawebgrid. It works beautifully until I edit the data. I have a button which fills the current data down to the cells below it. That fills the contents
on screen but defaults back to the original cell values with each click. If I enter something in a different column the column previously changed returns to empty values. If I change the contents below the current cell, everything above that returns to blank.
I have tried the following code in the loop but it doesn't work either.
ds.Tables.Rows[x][currcol] = currfill;
How can I maintain the changes? My ultrawebgrid has view state turned on. Any other suggestions?