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

Question

Hello Everyone I have list items. This 3 records contain images that is image path from database. I want to get total size of the image group by ArchievedName . 1st item 2nd item 3rd item I have tried List objDocumentUserSetup = new List (); bjDocumentUserSetup = objUserSetUp1.AsEnumerable().Select(m => new Tble_Documents() { ArchievedName = m.ArchievedName UpdatedDate = m.UpdatedDate Fullname = m.Fullname FilePath = m.FilePath + m.Parent_File_Name + _ + m.Child_File_Name docCount = m.docCount FileSize = FormatBytes( new System.IO.FileInfo(m.FilePath + m.Parent_File_Name + _ + m.Child_File_Name).Length) /*How can do here?*/ }).ToList(); private static string FormatBytes( long bytes) { string [] Suffix = { B  KB  MB  GB  TB }; int i; double dblSByte = bytes; for (i = 0; i = 1024; i++ bytes /= 1024) { dblSByte = bytes / 1024.0; } return String.Format( {0:0.##} {1}  dblSByte Suffix[i]); } Please help me.

Nitin Sontakke · Answer

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?

sudipta sanyal · Answer

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}	{1} itm.Name itm.Title); }

Nitin Sontakke · Answer

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?

Mani Kandan · Answer

Thanks Nitin Sir I will try as you say. And if I can not do that then I will inform.

Mani Kandan · Answer

Hello Nitin Yes I am getting each images .Length correctly and separately inside the bjDocumentUserSetup list.