Getting count of all repeated rows in a datatable in C#

I am filling a dataset by running a stored procedure, and i am filling a datatable from the dataset.

DataSet RawDataSet = DataAccessHelper.RunProcedure("storedprocedureName");

//this will just return the dataset by running the procedure

DataTable RankTable = RawDataSet.Tables[0];

The Datatable has the below values:

Kamlakar Login 6/24/2014

Kamlakar Login 6/25/2014

Vinu Game 6/26/2014

Vinu Login 6/27/2014

Dilip Login 6/28/2014

Dilip Game 6/29/2014

Vinu Login 6/30/2014

Vinu Login 7/1/2014

Dilip Game 7/2/2014

Kamlakar Login 7/3/2014

Kamlakar Login 7/4/2014

Kamlakar Game 7/5/2014

I want to parse this dataTable and get how many times everyone has done an action, i.e how many times each row is repeated:

Kamlakar Login 3

Vinu Game 2

Vinu Login 4

Kamlakar Login 1

Kamlakar Game 2

I am new to C#. This can be done using count(*) in SQL but I need to do this using C#. Please let me know if there are any ways to achieve this.

I have searched SO but all posts are related to removing the duplicates/finding the duplicates, which does not solve my purpose.

Updated on 19-Jan-2015

var query = RankTable.AsEnumerable()
                    .GroupBy(r => new { Name = r.Field<string>("Name"), Action = r.Field<string>("Action") })
                    .Select(grp => new
                    {
                        Name = grp.Key.Name,
                        Action = grp.Key.Action,
                        Count = grp.Count()
                    });

forum

Getting count of all repeated rows in a datatable in C#

Anonymous User

1 Answers

Liked By