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

Dorababu Meka

15y2.2k.NET

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.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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 < EmpIds.Length; 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();
}
}
0
Dorababu Meka15y ago
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..
0
Vulpes15y ago
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 < EmpIds.Length; 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?

0
Dorababu Meka15y ago
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 < EmpIDs.Length; 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
0
Dorababu Meka15y ago
I just googled and found this

I am using visual studio 2005 will there be problems further if i use this
0
Dorababu Meka15y ago
Hi i wrote as follows

d.Add(EmpID,new List{Payperiodnumber});

But i am getting error as

A new expression requires () or [] after type
0
Dorababu Meka15y ago
Thanks vulpes i will try this and let you know. Can we skip if we get multiple id while adding to the dictionary
0
Vulpes15y ago
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();
}
}
0