Count of types from datagridview

Question

I have a datagrid view like this: private void Form1_Load(object sender, EventArgs e) { AddRowsInDatagridView(0,"Rohim", "Apple", "3", "2"); AddRowsInDatagridView(1,"Karim", "Banana", "", "3"); AddRowsInDatagridView(2,"Karim", "Guava", "5", "7"); AddRowsInDatagridView(3,"Rohim", "Coconut", "6", "8"); AddRowsInDatagridView(4,"Karim", "Banana", "3", "5"); AddRowsInDatagridView(5,"Rohim", "Jackfruit", "2", "9"); AddRowsInDatagridView(6,"Rohim", "Apple", "1", "12"); AddRowsInDatagridView(7, "Rohim", "Apple", "1", "12"); AddRowsInDatagridView(8, "Karim", "Guava", "5", "7"); AddRowsInDatagridView(7, "Rohim", "Palm", "1", "12"); AddRowsInDatagridView(8, "Shovan", "Date", "5", "7"); AddRowsInDatagridView(9, "Karim", "Banana", "3", "5"); }   Expected: Rohim has = 4 types of fruit. Karim has = 2 types of fruit. Shovan has = 1 type of fruits.

Amit Gupta · Accepted Answer

Dictionary totals = new Dictionary ();
for (int i = 0; i < GridView1.Rows.Count; ++i)
{
string group = Convert.ToInt32(GridView1.Rows[i].Cells["Group"].Value);
int qty = Convert.ToInt32(GridView1.Rows[i].Cells["QTY"].Value);
if (totals.ContainsKey(group) == false)
totals.Add(group, qty);
else
totals[group] += qty;
}
foreach (string group in totals.Keys)
Console.WriteLine(string.Format("{0} : {1}", group, totals[group].ToString()));

Shovan Saha · Answer

Dear Amit Sir, thanks for your help. But I want to know how many types of fruit for Rohim / Karim / Shovan? I can clarify like this:   private void Form1_Load(object sender, EventArgs e) { AddRowsInDatagridView("Rohim", "Apple"); AddRowsInDatagridView("Karim", "Banana"); AddRowsInDatagridView("Karim", "Guava"); AddRowsInDatagridView("Rohim", "Coconut"); AddRowsInDatagridView("Karim", "Banana"); AddRowsInDatagridView("Rohim", "Jackfruit"); AddRowsInDatagridView("Rohim", "Apple"); AddRowsInDatagridView("Rohim", "Apple"); AddRowsInDatagridView("Karim", "Guava"); AddRowsInDatagridView("Rohim", "Palm"); AddRowsInDatagridView("Shovan", "Date"); AddRowsInDatagridView("Karim", "Banana"); }  Now my question: How many types of fruit are for Rahim? Expected Answer :  4 How many types of fruit are for Karim? Expected Answer : 2 How many types of fruit are for Shovan? Expected Answer : 1

Amit Gupta · Answer

Your code has 4 columns without the names, which one to count for sum as your expected result doesn't match with the code, please clarify