Page 1 of 1

TableAdapter-Transaction

Posted: Wed 01 Aug 2007 08:13
by Zero-G.
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

Posted: Wed 01 Aug 2007 08:50
by Alexey
Datasets know nothing about storage engine. So I don't understand what is the problem.

Posted: Wed 01 Aug 2007 08:54
by Zero-G.
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

Posted: Wed 01 Aug 2007 09:27
by Alexey
You should do this yourself. Use BeginTransaction(), etc. methods of MySqlConnection class.