Looping and updating simulatneously problem
I have a problem.
I am using the OLEDataProvider class.
By looping through a table of records via the data reader, I use a connection item called "conn".
Within this loop, when I find a condition which matches my condition, I then update that particular record (I want to). I am updating using an OLEDBcommand, which also makes use of the connection iteam "conn". This is where the problem lies. I can't update within this loop becoz the loop itself is using this connection item. I am try ing to look for a way to avoid creating a separate connection item for updating purposes. Does anybody know a way out of this?