|
-
May 30th, 2003, 09:31 AM
#1
Thread Starter
Hyperactive Member
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|