Thanks Mike, it was just the way I was using and manipulating the datatable and set that was the issue, not the UltraGrid itself.

Hi Mike,

I have a DataTable set to being the datasource of the UltraGrid – It’s declared at the top of the class, then when loading the data, a new instance of it is created and the data is filled in.

However, when running the following code at the start of my UPDATE statement, the number of rows returned is only the number of rows in the current grid, not including the deleted rows.

tr = con.BeginTransaction()
For Each dr As DataRow In commDt.Rows
If dr.RowState = DataRowState.Deleted Then
Try
Dim Dc As New OleDbCommand