is there a way to change the key of an item within a collection?

[dx]

Is anyone aware of a way to change the key (string) within a collection . I
have a collection of items, when a 'new' item is added it has a temporary
key which is used until the collection is saved to the database. I'd like to
update the key to reflect the actual Id assigned by the db once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Thanks,
Stan

[Herfried K. Wagner [MVP]]

"dx" <de*********@yahoo.com> schrieb:

Is anyone aware of a way to change the key (string) within a collection .
I have a collection of items, when a 'new' item is added it has a
temporary key which is used until the collection is saved to the database.
I'd like to update the key to reflect the actual Id assigned by the db
once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Remove the item and add it with the new key.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[dx]

That does not work for me. That is why I asked about changing the Key
string.


"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

"dx" <de*********@yahoo.com> schrieb:

Is anyone aware of a way to change the key (string) within a collection .
I have a collection of items, when a 'new' item is added it has a
temporary key which is used until the collection is saved to the
database. I'd like to update the key to reflect the actual Id assigned by
the db once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Remove the item and add it with the new key.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Herfried K. Wagner [MVP]]

"dx" <de*********@yahoo.com> schrieb:

Is anyone aware of a way to change the key (string) within a collection .
I have a collection of items, when a 'new' item is added it has a
temporary key which is used until the collection is saved to the database.
I'd like to update the key to reflect the actual Id assigned by the db
once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Remove the item and add it with the new key.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[dx]

That does not work for me. That is why I asked about changing the Key
string.


"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

"dx" <de*********@yahoo.com> schrieb:

Is anyone aware of a way to change the key (string) within a collection .
I have a collection of items, when a 'new' item is added it has a
temporary key which is used until the collection is saved to the
database. I'd like to update the key to reflect the actual Id assigned by
the db once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Remove the item and add it with the new key.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Herfried K. Wagner [MVP]]

"dx" <de*********@yahoo.com> schrieb:

That does not work for me. That is why I asked about changing the Key
string.

Huh?! What doesn't work with removing the item using its old key and
re-adding the object using its new key?

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Herfried K. Wagner [MVP]]

"dx" <de*********@yahoo.com> schrieb:

That does not work for me. That is why I asked about changing the Key
string.

Huh?! What doesn't work with removing the item using its old key and
re-adding the object using its new key?

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Jay B. Harlow [MVP - Outlook]]

Stan,
What I normally do is make the "key" read-only on the object being contained
which prevents this problem in the first place.

When I do have objects that the "key" can change, I normally have the object
being contained raise an event when the "key" changes. The collection
handles this event and does as Herfried suggests, removes the old key and
adds the new key, which may entail removing the object under the old key &
adding the object under the new key.

I do however favor immutable keys as its easier to maintain & program...

Hope this helps
Jay

"dx" <de*********@yahoo.com> wrote in message
news:9i****************@fe05.lga...

Is anyone aware of a way to change the key (string) within a collection .
I have a collection of items, when a 'new' item is added it has a
temporary key which is used until the collection is saved to the database.
I'd like to update the key to reflect the actual Id assigned by the db
once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Thanks,
Stan

[Jay B. Harlow [MVP - Outlook]]

Stan,
What I normally do is make the "key" read-only on the object being contained
which prevents this problem in the first place.

When I do have objects that the "key" can change, I normally have the object
being contained raise an event when the "key" changes. The collection
handles this event and does as Herfried suggests, removes the old key and
adds the new key, which may entail removing the object under the old key &
adding the object under the new key.

I do however favor immutable keys as its easier to maintain & program...

Hope this helps
Jay

"dx" <de*********@yahoo.com> wrote in message
news:9i****************@fe05.lga...

Is anyone aware of a way to change the key (string) within a collection .
I have a collection of items, when a 'new' item is added it has a
temporary key which is used until the collection is saved to the database.
I'd like to update the key to reflect the actual Id assigned by the db
once saved.

The key is readonly when i access like this:

Me.Keys.Item(nIdx)

Thanks,
Stan