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(EmpID,new 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

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (8)