Simple Datagridview code

Question

m new to C#.NET and am stuck I need to compare all the rows of a datagridview at the values of a given column and if the values in the given column of the two rows dont match return the value of the column of that current row.Hence getting unique values. (Am sure someone has done this before here). That is given that you will be checking if (datagridView.Rows[z].Cells[0].Value.toString() != datagridView.Rows[z+1].Cells[0].Value.toString()) So it should return the value of the first. This should run thru the full datagrid returning the unique values only.

Marto · Answer

hi I need to loop through the rows of the datagrid and compare the values of the row at a particular column with the next row at the particular column and if they don't match get the value of the current row. For instance: We have 2 rows column headers : Date Age Gender Ref Row 1 09/09/08 45 Male 66 Row 2 13/09/08 67 Male 54 Row 3 15/09/08 67 Male 54 Row 4 15/09/08 67 Male 57 So it compares the Ref value of the first row to the next and if they dont match returns the first row value of the Ref column. Hence getting unique values of the Ref Column.

Anna Hawks · Answer

I'm not sure I understand the question -- are you asking how to cycle through all the rows in the datagrid to compare them or how to remove the non-unique rows. Do you want to delete the data that isn't unique or just not display it or change it to another value?