TableAdapter-Transaction

Zero-G. · Post by **Zero-G.** » Wed 01 Aug 2007 08:13

Hey

I use VB.NET 2005 & your controls v4

I have changed the Engines of my tables from MyISAM to InnoDB. One of the reasons was, that InnoDB provides Transaction.
So, the most Database related queries where made from DataSets (with TableAdapters). - So, is there a possibility to re-tool the DataSets with transactions? Or how to do this?

THX

Alexey · Post by **Alexey** » Wed 01 Aug 2007 08:50

Datasets know nothing about storage engine. So I don't understand what is the problem.

Zero-G. · Post by **Zero-G.** » Wed 01 Aug 2007 08:54

Hey

Yes, I know, but how to provide transaction save update/insert Statements?

Or does the DataSet itself provides any kind of technologie for transaction?

THX

Alexey · Post by **Alexey** » Wed 01 Aug 2007 09:27

You should do this yourself. Use BeginTransaction(), etc. methods of MySqlConnection class.