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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Guest

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

Post by Guest » Fri 14 Oct 2005 08:12

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

Serious

Post by Serious » Fri 14 Oct 2005 08:57

Please specify your .NET Framework version, MySQLDirect .NET version.

Guest

Post by Guest » Fri 14 Oct 2005 10:43

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)

Serious

Post by Serious » Fri 14 Oct 2005 13:08

We have fixed this problem for MySQLDirect .NET.
Look forward for the next build.

Guest

Post by Guest » Fri 14 Oct 2005 14:23

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.

enzers
Posts: 4
Joined: Mon 17 Oct 2005 19:52

I have the same problem

Post by enzers » Mon 17 Oct 2005 20:02

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.

Post Reply