How to comparing multiple itemname in the same list using c#

Abhilash J A

How to compare same names from List items (like ItemName==ItemName(eg:- car is duplicated 3 times)) using c# code?

This is my SQL Procedure Result:-

Id ItemName

1370 Air Freshner
2484 Air Freshner
604 Airbed Item
718 Alarm Clock
2576 Alarm Clock
2834 All terrain transporter
1618 App
2938 App
2509 Apple Juice Carton
321 Apple Sauce Jar
1086 Can
606 Car
966 Car

How to write in c# code:-

Here "tempList" is contain list ItemName with id from my sql query I try,

foreach (var item in tempList)

{

If(item.ItemName=="Car"){

ItemList.Add(new SelectListItem { Text = item.ItemName, Value = item.Id.ToString() });

}

In this 'tempList' contains query result in List<> format. Then How to compare same 'ItemName' like (if there is 3 car (same name) then campare like ==) from procedure and append there ids like (Value = "1086,606,966") in checkbox Text

2 Replies

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

Manas Mohapatra10y ago
Accepted answer
Try with below code:

List tempList1 = new List()
{
new temp1{ID = 9, Name = "Test9"},
new temp1{ID = 4, Name = "Test8"},
new temp1{ID = 1, Name = "Test9"},
new temp1{ID = 2, Name = "Test2"},
new temp1{ID = 5, Name = "Test9"}
};

Dictionary tempDict = new Dictionary();

foreach (var temp in tempList1)
{
   if (tempDict.ContainsKey(temp.Name))
   {
      tempDict[temp.Name] = tempDict[temp.Name] + "," + temp.ID;
   }
   else
   {
      tempDict.Add(temp.Name, temp.ID.ToString());
   }
}

List ItemList = new List();

foreach (var item in tempDict)
{
   ItemList.Add(new SelectListItem { Text = item.Key, Value = item.Value });
}
+1
Abhilash J A10y ago
To,
Manas Mohapatra
Your are right sir. Thank you sir....
Thank you for your reply Sir
0