How to use distinct() in integer variables using mvc c#?

Abhilash J A

Hello Sir,

string AgencyIds = "";

List objList = new List();
objList = "This "objList" variable contain stored procedure result that is list of ids";
foreach (var items in objList)
{
AgencyIds = AgencyIds + items.agencyID + ",";
}

Output of the AgencyIds is like this:- 14,14,14,14,15,16,11,11,11 like that...

how to get distinct 'items.agencyID' (ie, AgencyIds) with comma for each AgencyIds using c# code?

But I want output like this:= AgencyIds = 14,15,16,11, like that...

4 Replies

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

Abhilash J A10y ago
Hello Saineshwar Bageri Sir, I am using AgencyIds in ViewModel class as sting type like that
var redirectWithManyIds = new ViewModel.TopLineToExposure
{ AgencyIds = AgencyIds};
0
Saineshwar Bageri10y ago
where you want to use this Ids
0
Abhilash J A10y ago
Thank you for replay me Sir!

Excuse me Saineshwar Bageri,

after the foreach loop, How can I ger or use distinct AgencyIds also with comma ?
0
Saineshwar Bageri10y ago
Answer :- Use Linq
string AgencyIds = "";
List objList = new List() {

new SelectListItem { Text="14",Value="14"},
new SelectListItem { Text="14",Value="14"},
new SelectListItem { Text="14",Value="14"},
new SelectListItem { Text="14",Value="14"},
new SelectListItem { Text="15",Value="15"},
new SelectListItem { Text="16",Value="16"},
new SelectListItem { Text="11",Value="11"},
new SelectListItem { Text="11",Value="11"},
new SelectListItem { Text="11",Value="11"},

};

var Listout = (from a in objList
select a.Value).Distinct();

foreach (var items in Listout)
{
AgencyIds = AgencyIds + items + ",";
}
0