What's the best method to choose per my requirement to store the values

Question

I have a grid view with some data and check boxes. Assume that my data is as follows:

Checkbox	EmpID	PayID
	123	1
	1234	1
	1234	2

I would like to store the corresponding PayID values as per the EmpID exists. If I select both from the check boxes available I would like to check which payid belongs to which EmpID can any one give me an idea to implement this please.

Vulpes · Answer

IIRC collection initializers weren't introduced until C# 3.0 and so won't work in VS 2005 (C# 2.0). Also using CodeDom to add C# 3.0 features to C# 2.0 is not a good idea IMO. However here's an alternative formulation which should work in VS 2005 and might be more suitable for what you're doing in any case: using System; using System.Collections.Generic; class Test { static void Main() { int[] EmpIds = new int[]{123 1234 1234}; int[] PayIds = new int[]{1 1 2}; Dictionary > dict = new Dictionary >(); // populate dictionary for(int i = 0; i { if (!dict.ContainsKey(EmpIds[i])) { List values = new List (); dict.Add(EmpIds[i] values); } dict[EmpIds[i]].Add(PayIds[i]); } // retrieve foreach(int k in dict.Keys) { foreach(int v in dict[k]) Console.WriteLine({0} -> {1} k v); Console.WriteLine(); } Console.ReadKey(); } }

Vulpes · Answer

It looks like for a given EmpID there might be multiple PayIds. If that's the case then you could use a Dictionary >. Here's a quick console app to show how that would work: using System; using System.Collections.Generic; class Test { static void Main() { var dict = new Dictionary >(); // populate dict.Add(123 new List {1}); dict.Add(1234 new List {1 2}); // retrieve foreach(int k in dict.Keys) { foreach(int v in dict[k]) Console.WriteLine({0} -> {1} k v); Console.WriteLine(); } Console.ReadKey(); } }

Dorababu Meka · Answer

Ok i will test it tomorrow as per my requirement and will let you know.. I hope this will give the one as i required.. Thanks Vulpes..

Vulpes · Answer

The code definitely works when a key has more than 2 values. If I change my original example to: using System; using System.Collections.Generic; class Test { static void Main() { int[] EmpIds = new int[]{123 1234 1234 123 1234 123}; int[] PayIds = new int[]{1 1 2 3 3 2}; Dictionary > dict = new Dictionary >(); // populate dictionary for(int i = 0; i { if (!dict.ContainsKey(EmpIds[i])) { List values = new List (); dict.Add(EmpIds[i] values); } dict[EmpIds[i]].Add(PayIds[i]); } // retrieve foreach(int k in dict.Keys) { foreach(int v in dict[k]) Console.WriteLine({0} -> {1} k v); Console.WriteLine(); } Console.ReadKey(); } } then as expected the output is: 123 -> 1 123 -> 3 123 -> 2 1234 -> 1 1234 -> 2 1234 -> 3 Are you sure that the original arrays are of the same length and that the keys and values correspond with each other (i.e. have the same indices) in both arrays?

Dorababu Meka · Answer

Hi Vulpes if have PayID values more than 2 will this works i tried this as per given EmpIDs = (int[])arrEmpID.ToArray(typeof(int)); allPayPeriodIDs = (int[])arrAllPayPeriods.ToArray(typeof(int)); for (int i = 0; i { if (!dictEmpID_all_PayID.ContainsKey(EmpIDs[i])) { List values = new List (); dictEmpID_all_PayID.Add(EmpIDs[i] values); } dictEmpID_all_PayID[EmpIDs[i]].Add(allPayPeriodIDs[i]); } foreach (int j in dictEmpID_all_PayID.Keys) { foreach (int k in dictEmpID_all_PayID[j]) { lstPayIDs.Add(k); } } But only 2 values are storing . I will get EmpID count as 2 and allPayPeriodIDs values 9 in this code can u help me on that

Dorababu Meka · Answer

I just googled and found this I am using visual studio 2005 will there be problems further if i use this

Dorababu Meka · Answer

Hi i wrote as follows d.Add(EmpIDnew List {Payperiodnumber}); But i am getting error as A new expression requires () or [] after type

Dorababu Meka · Answer

Thanks vulpes i will try this and let you know. Can we skip if we get multiple id while adding to the dictionary