Hello.
I'm making a program which connects to a MySQL dtabase, reads some tables, and populates comboboxes. The user fills a form with the comboboxes and textboxes and I'm ready to update the database.
I want to use an MSRDC control but I don't want to use an SQL command because the database has an Auto Inc Key which I want to retrieve after I update the database (also it should be faster).
So far I have this:

Form1.MSRDCSpot.Connect = ConnectionString
Form1.MSRDCSpot.Refresh

which works perfectly if I want to read from the database, but when I write

MSRDCSpot.BeginTrans

it replies "The connection is not open".
Can anyone give me an example as i can't find anything on the internet (without the use of SQL commands).
Thanks.