Posted 8 September 2017, 1:56 pm EST
I’ve bound Dataset to the spread using the DataSource Property.if i paste any data from excel sheet to Forpoint spread sheet,I need to call the below code to get the Modified records.
DataTable datatable = (DataTable)fpspread1.ActiveSheet.DataSource;
foreach (DataRow dr in datatable.Rows)
DataRow modRows = dt.Select("", "", DataViewRowState.ModifiedCurrent);
My question is How can we change the above code to work more efficiently?( if we paste only few rows why we should call endedit in all rows)
appreciate your reply