how to count duplicate values in datagridview c# forms

Question

hai friends  please help me to count duplicate values from datagridview in c# windows forms ... HERE I NEED TO COUNT TOTAL NUMBER OF P's IN A ROW AS SHOWN BELOW s.no name Jan-01 Jan-02 Jan-03 Jan-04 Jan-05 TOTAL PRESENT 1 chiru p p A P P 4 2 venu P P P A P 4 3 naveen P P A P A 3 4 tanu P A P P P 4 5 tanushree A P A P P 3 6 vandu A P A P A 2 THANKS IN ADVANCE

Vulpes · Answer

Try this code: foreach(DataGridViewRow row in dataGridView1.Rows) { if (row.IsNewRow) break; int total = 0; for(int i = 2; i { if (row.Cells[i].Value.ToString() == P) total++; } row.Cells[row.Cells.Count - 1].Value = total; }

Manoj Bhoir · Answer

Hi Instead of calculating after loading data in gridview you can calculate Total Present and Total Absent in your SQL Select Statement you are using to bind data to your grid view. Try this Query : SELECT * FROM dbo. YourTableName T CROSS APPLY ( SELECT Count(*) FROM (VALUES ([Jan-01]) ([Jan-02]) ([Jan-03]) ([Jan-04]) ([Jan-05])) C (Val) WHERE Val = 'P' ) A (Presnet) CROSS APPLY ( SELECT Count(*) FROM (VALUES ([Jan-01]) ([Jan-02]) ([Jan-03]) ([Jan-04]) ([Jan-05])) C (Val) WHERE Val = 'A' ) B (Absent)

Manas Mohapatra · Answer

Hi Mano Please find below code for VB.NET: For Each row As DataGridViewRow In dataGridView1.Rows If row.IsNewRow Then Exit For End If Dim total As Integer = 0 For i As Integer = 2 To row.Cells.Count - 2 If row.Cells(i).Value.ToString() = P Then total += 1 End If Next row.Cells(row.Cells.Count - 1).Value = total Next

Govinda Rajulu Yemineni · Answer

Hi below one is VB.Net code you can try this For Each row As DataGridViewRow In DataGridView1.Rows Dim total As Integer = 0 If Not row.IsNewRow Then For i As Integer = 2 To row.Cells.Count - 1 If row.Cells(i).Value.ToString() = P Then total = total + 1 End If Next End If row.Cells(row.Cells.Count - 1).Value = total Next

Mano Haran · Answer

I want the same on vb.net please help me

Mano Haran · Answer

I want the same on vb.net please help me

vyx cmyx · Answer

>>Jignesh Trivedi Agree with Vulpes... but I think it is good idea if you fetch this data when you bind the grid... What you mean fetch first. Can you give sample code here.. I know vulpes has its good idea on that coding also.. but do you have other code thanks

Jignesh Trivedi · Answer

hi Agree with Vulpes... but I think it is good idea if you fetch this data when you bind the grid...

s.no	name	Jan-01	Jan-02	Jan-03	Jan-04	Jan-05	TOTAL PRESENT
1	chiru	p	p	A	P	P	4
2	venu	P	P	P	A	P	4
3	naveen	P	P	A	P	A	3
4	tanu	P	A	P	P	P	4
5	tanushree	A	P	A	P	P	3
6	vandu	A	P	A	P	A	2