Re: Can I add the SQL of a DataAdapter into a Transaction
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Sun, 6 Jan 2008 17:01:02 -0500
Amelia wrote:
I need to retrieve a set of data to work on from a DB table. BEfore IThere was no way for you to know it (except maybe by browsing through some
work on the data I need to update these records as "Being Processed"
and then go back to process the required records.
What I was going to do was to retrieve records into a DataSet, update
status in the DB table and then loop through DataSet to update
records - BUT jsut to be sure, I still want to wrap up retrieval and
update of records in a transaction. Is this possible?
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.
However, you should probably run this task by someone to verify that you
actually need to do this process in a loop. I have rarely seen a looped
update that could not be rewritten as a more robust and efficient set
operation. What DB are you using?
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- Follow-Ups:
- Prev by Date: Re: Access project image files
- Next by Date: Re: Can I add the SQL of a DataAdapter into a Transaction
- Previous by thread: Re: Access project image files
- Next by thread: Re: Can I add the SQL of a DataAdapter into a Transaction
- Index(es):
Relevant Pages
|
|
