Compare datagrid rows

Question

Hi dear ;

I wanna compare datagrid rows and then make do something .

For Example ;

Number Name
90 ABC
80 XYZ
60 XXX
90 ABC

for (int i = 0; i < dataGridView1.Rows.Count; i++)

if (dataGridView1.Rows[i].Cells[0].Value == dataGridView1.Rows[i].Cells[0].Value)

{

//Do Something//

}

else

{

//Do Something//

}

Amit Thorat · Answer

Hi Bimol If you are looking to remove rows with duplicate entries you can try something like this foreach (currentrow=0;currentrow { var rowtoComp = datagridview1.rows[currentrow]; foreach(var row in datagridview1.rows) if (rowtoComp.equls(row) { // Your Logic. } }

Demir Acar · Answer

I want to do dynamically Maybe if I cant find any respond then try to that  Actullay one way can be I want ; if my grid has a this value Number 90 90 or Number 90 80 this code is working . for (int i = 0; i for (int ii = i + 1; ii { if (dataGridView1.Rows[i].Cells[0].Value.ToString() == dataGridView1.Rows[ii].Cells[0].Value.ToString()) { MessageBox.Show(Test); } else { MessageBox.Show(mest); } } } } if my grid has a this value ; Number 90 80 70 80 90 80 above code in looped and not working .

Anupam Singh · Answer

how about DataSet ds = new DataSet(); ds.ReadXml( @ d:\Deneme.xml ); DataTable dt = ds.Tables[0]; // then create copy of it.

Demir Acar · Answer

XmlTextWriter xmlDocument = new XmlTextWriter (@ d:\Deneme.xml  System . Text . Encoding . GetEncoding ( ISO-8859-9 )); xmlDocument . Formatting = Formatting . Indented ; xmlDocument . Indentation = 5 ; xmlDocument . WriteStartDocument (); xmlDocument . WriteStartElement ( SALES_INVOICES ); for ( int i = 0 ; i dataGridView1 . Rows . Count ; i ++) { xmlDocument . WriteElementString ( INVOICE ); xmlDocument . WriteElementString ( TYPE  dataGridView1 . Rows [ i ]. Cells [ 0 ]. Value . ToString ()); xmlDocument . WriteEndElement (); } } xmlDocument . WriteEndElement (); xmlDocument . Close (); MessageBox . Show ( Xml Created. ); }

Anupam Singh · Answer

share your xml file.

Demir Acar · Answer

No I can't :) due to XML class Actually I am reading value from Excel and write to it to XML therefore I can't use datatable or dataset My XML tags is different . Maybe someone did it before .

Anupam Singh · Answer

hmm.. might be. then try : you must be binding grid for datatable or dataset. try to make copy of it and then you have to compare using 2 for loops datatable1 t1=new datatable1();// fill data in table datatable2 t2=t1.Copy(); for( int i = 0; i datatable1 .Rows.Count; i++ ) { for( int j= 0; j datatable2 .Rows.Count; j++ ) { if( datatable1. Rows[i][0]. == datatable2. Rows[j][0] ) { // do your work.. } } }

Demir Acar · Answer

No didn't work  if my grid has a this value Number 90 90 or Number 90 80 this code is working . for (int i = 0; i for (int ii = i + 1; ii { if (dataGridView1.Rows[i].Cells[0].Value.ToString() == dataGridView1.Rows[ii].Cells[0].Value.ToString()) { MessageBox.Show(Test); } else { MessageBox.Show(mest); } } } } if my grid has a this value ; Number 90 80 70 80 90 80 above code in looped and not working .

Anupam Singh · Answer

Ok. then try for (int i = 0; i { string s=dataGridView1.Rows[i].Cells[0].Value.ToString(); for(int j = 0; j { if(s==dataGridView1.Rows[j].Cells[0].Value.ToString()) { // do something with matching } } else { //Do Something// } } } } this is not tested. so please refactor before using.

Demir Acar · Answer

Yes please I already eleborated So Cells[0] if (dataGridView1.Rows[i].Cells[0].Value == dataGridView1.Rows[i].Cells[0].Value)

Anupam Singh · Answer

in the same column ? please elaborate ?

Demir Acar · Answer

I wanna compare number value another rows in same grid .

Anupam Singh · Answer

Agree with Sivaraman  Birol I think dataGridView1.Rows[i].Cells[0].Value == dataGridView1.Rows[i].Cells[0].Value should be replaced with dataGridView1.Rows[i].Cells[0].Value == dataGridView2. Rows[i].Cells[0].Value // grid which you want to compare.

Demir Acar · Answer

Can you see above code  if u add this line you dont take that error . for (int i = 0; i < dataGridView1.Rows.Count; i++)

Sivaraman Dhamodaran · Answer

The below code does not require any conditional checks as it always pass. Are you missing something? if ( dataGridView1.Rows[i].Cells[0].Value == dataGridView1.Rows[i].Cells[0].Value ) { //Do Something// } else { //Do Something// } }