Page 1 of 1

ERROR [Duplicate name 'p2' in parameters collection] after Update DataAdapter in Example

Posted: Fri 14 Oct 2005 08:12
by Guest
Dear Core Lab!
Sorry for my English.
When I run your examples DataSet or DbTable (VB projects or exe) and change data in more then one cells in grid and then press Update button I get this error:
----------
An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll

Additional information: Duplicate name 'p2' in parameters collection
---------
If I change only one cell in grid and then press Update everything is ok!

Thank you for answer.
Pavel

Posted: Fri 14 Oct 2005 08:57
by Serious
Please specify your .NET Framework version, MySQLDirect .NET version.

Posted: Fri 14 Oct 2005 10:43
by Guest
Serious wrote:Please specify your .NET Framework version, MySQLDirect .NET version.
.NET Framework 1.1 Version 1.1.4322 SP1
MySQLDirect .NET version 3.00 (I downloaded it yesterday)

Posted: Fri 14 Oct 2005 13:08
by Serious
We have fixed this problem for MySQLDirect .NET.
Look forward for the next build.

Posted: Fri 14 Oct 2005 14:23
by Guest
Serious wrote:We have fixed this problem for MySQLDirect .NET.
Look forward for the next build.
i.e. now if i want to edit data in grid I can not use MySqlCommandBuilder to create auto created insert and update statments.

I'm going to buy MySQLDirect .NET Pro. Could you possible presume when new build will be released?

Thank you.

I have the same problem

Posted: Mon 17 Oct 2005 20:02
by enzers
I've just spent the entire day trying to find the source of this error, when I finally turned to your forum and found it is a bug in MySQLDirect.NET. The inability to update more than one record column at a time is a serious flaw.

Since you state you have fixed the problem, it would be very helpful to know your plans for releasing the next build, as it will have significant impact on how I proceed with my current project.

I have really liked what I've seen in your product so far, but this needs a solution now.