If list contain duplicate value then get total count - C#

Thanks Nitin Sir,

 

I will try as you say. And if I can not do that, then I will inform.  

Perfect. 

 

Then I think all you have do is make it Int32 (or Int64) and use solution posted by Sudipta for doing group by.

 

Am I right? Or am i missing some other part of the puzzle? 

Hello Nitin,

 

Yes, I am getting each images.Length 

correctly and separately inside the bjDocumentUserSetup list.

Try this

 

DataTable table = new DataTable();

table.Columns.Add("Name", typeof(string));

table.Columns.Add("Title", typeof(string));

table.Columns.Add("Quantity", typeof(int));

// Data for test

table.Rows.Add("ABC", "Item_name", 6);

table.Rows.Add("ABC", "Item_name", 6);

table.Rows.Add("ABC2", "Item_name", 6);

table.Rows.Add("ABC2", "Item_name", 6);

table.Rows.Add("ABC2", "Item_name", 6);

table.Rows.Add("ABC2", "Item_name", 6);

// Query with Linq

var query = from row in table.AsEnumerable()

group row by new {

name = row.Field("Name"),

title = row.Field("Title")

} into GrpNameTitle

select new {

Name = GrpNameTitle.Key.name + " (" + GrpNameTitle.Count() + ")",

Title = GrpNameTitle.Key.title,

Quantity = GrpNameTitle.First().Field("Quantity")

};

foreach (var itm in query)

{

Console.WriteLine("{0}\t{1}", itm.Name, itm.Title);

}

This is a strictly personal level comment:

 

Somehow I always fail to understand why people try to achieve everything in just one go. May be it's just that I am not brilliant enough but I often break problem into several small pieces and solve those small pieces, which are often manageable.

 

Coming back to your question..you are stating that you want to GROUP BY image sizes on some different property. In that case your FileSize property should be integer. If you add KB, MB to it I am not sure how would you total it later.

 

I would first get all file sizes of all the files and the think of grouping them.

 

Because I think best in back-end terms, I would even create a column and update it with values and then do the group by in db itself.

 

If you are proficient with linq, etc. I suggest you just first update the properties in classes.

 

Are you getting .Length correctly?