I have an array of DataTables and Adapters
In this instance I have assigned one of the tables to a unique DataTable varable "rs" which is associated with the giLastTableIndex index as appears in the update command below
I wish to delete a row and update the DataTable
The update results in the concurrency violationCode:Dim rRow As DataRow For Each rRow In rs.Rows With rRow If .Item("DVN_SHAFT") = sDVN_SHAFT And .Item("DP") = fDP And .Item("PR_ANG") = fPR_ANG And .Item("DVR_N_T") = fDVR_N_T And .Item("DVN_N_T") = fDVN_N_T And .Item("DVR_AD") = fDVR_AD And .Item("DVN_AD") = fDVN_AD Then rRow.Delete() Exit For End If End With Next rRow iRet = gda(giLastTableIndex).Update(gdt(giLastTableIndex))
I have looked for instances where I am holding the DataTable open with another variable and I do not believe I have any.
Suggestions?




Reply With Quote