name value pair

[Andy Sutorius via DotNetMonster.com]

Hi,

What collection can I use to store name value pairs that contain duplicates
in both columns?

Thanks,

Andy

 

[Yunus Emre ALPÖZEN [MCSD.NET]]

You can use a datatable which is to generic...

But if both column's composition is unique, u can use hash table for fast
access. For instance,

Sample Data:
A 1
B 1
C 2
A 2
B 3

If u have data like this,

u can use hash table
either
concatenating key value pairs with a special separator such as "$_$".
and use this string as hash value
or
just use keys as keys and use an arraylist for the changing values
A shows an arraylist containing 1,2
B shows an arraylist containing 1, 3
C should show aan arraylist containing 2

Hope this helps,

 

[Guest]

I don't thinks you can add
A 1
B 1
C 2
A 2
B 3

to a Hashtable. Using Hashtable, key must be unique. In above data, it will
throw ArgumentException: Item has already been used...

Elton Wang

You can use a datatable which is to generic...

But if both column's composition is unique, u can use hash table for fast
access. For instance,

Sample Data:
A 1
B 1
C 2
A 2
B 3

If u have data like this,

u can use hash table
either
concatenating key value pairs with a special separator such as "$_$".
and use this string as hash value
or
just use keys as keys and use an arraylist for the changing values
A shows an arraylist containing 1,2
B shows an arraylist containing 1, 3
C should show aan arraylist containing 2

Hope this helps,

 

[Yunus Emre ALPÖZEN [MCSD.NET]]

Just read my post again. I advised two solution two overcome this issue....

--

Thanks,
Yunus Emre ALPÖZEN
BSc, MCSD.NET

I don't thinks you can add
A 1
B 1
C 2
A 2
B 3

to a Hashtable. Using Hashtable, key must be unique. In above data, it
will
throw ArgumentException: Item has already been used...

Elton Wang

 

[Guest]

So I only think the second is wrong.

Just read my post again. I advised two solution two overcome this issue....

--

Thanks,
Yunus Emre ALPÖZEN
BSc, MCSD.NET

 

[Joseph A. De Guzman]

Use the NameValueCollection class.

Joseph

So I only think the second is wrong.

 

[Guest]

Hi Joseph,

It's quite interesting. NameValueCollection also stores key/value pairs by
unique keys. However, different from HashTable, it can 'Add' multi-values to
one key, e.g.
NvCollection.Add("A","1");
NvCollection.Add("A","2");
The result is that it concatenates values separated by comma, e.g.
NvCollection(“Aâ€) = “1,2â€. It seems you can use
string.split(",".ToCharArray()) to get an value array. But suppose there is
one value with comma, e.g. "1,000", how do you deal with it?

Elton Wang