Re: ConnectionPooling and the new parameter_collection.cs
Posted by:
Matt
Date: December 05, 2006 03:01PM
I had a similar error:
System.ArgumentException: Item has already been added. Key in dictionary: '?p7' Key being added: '?p7'
This error occurs in the following scenario:
In an invoicing app that I'm working on, a grid control for invoice items has these columns:
ID, InvNo, No, Description, Tax, Price, Qty, QtyC, Amount
The QtyC column is the same as Qty. It is used to compare the quantity entered with the quantity as it were, the last time the record was saved, for updating the inventory. This is the column that gave me trouble when saving.
Originally, I selected: SELECT ... Price, Qty, Qty AS QtyC, Amount ... since QtyC doesn't exist in the table. When updating, I think the error was generated because Qty is listed twice. To solve this problem, I changed the select to: SELECT ... Price, Qty, CONCAT(Qty) AS QtyC, Amount ...
I don't know why adding CONCAT works, but it does.
Subject
Written By
Posted
November 22, 2006 01:19AM
November 22, 2006 12:10PM
December 01, 2006 04:32AM
December 01, 2006 08:33AM
December 01, 2006 09:25AM
December 01, 2006 10:11AM
December 05, 2006 09:56AM
December 05, 2006 10:02AM
December 16, 2006 12:28PM
December 17, 2006 12:57PM
Re: ConnectionPooling and the new parameter_collection.cs
December 05, 2006 03:01PM
December 06, 2006 02:52AM
December 06, 2006 07:33AM
December 06, 2006 09:45AM
December 06, 2006 11:21AM
December 07, 2006 02:47AM
December 07, 2006 08:21AM
December 07, 2006 07:08PM