Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

Turn Off Autcommit

  Asked By: Wayne    Date: Jul 17    Category: Asp.net    Views: 1333

I need sample code in VB using either ADO(preferable) or ADO.net to
read 10000 records from one database and write these records to
another database.

However when I am writing the records to the other database I do not
want to commit each record. I want to write all the records at the
end as one big transation.

I read something in the documentation about turing off autocommit,
but I was unsure how to use this code.



1 Answer Found

Answer #1    Answered By: Cais Nguyen     Answered On: Jul 17

You will have to use transactions and put all your database writing command
inside that transaction. So when you call commit everything is stored or you can

Didn't find what you were looking for? Find more on Turn Off Autcommit Or get search suggestion and latest updates.