I am looking for 100 strings in a datagridview with 30000 rows. Iterating the datagridview 30000 times in an outer for loop and iterating another inner for loop 100 times and check if the searched string is found seems not efficiently because it means a iterating a loop 30000 x 100 = 3.000.000 times WoW...
What I want is if I found the string in a row of the datagridview is to set the whole row`s backcolor red and the first column which has a checkbox to true.
All 30000 rows are in the MyExtendedReader which is populated with the database data.
How can I search the DataGridView/DataTable fast?
this is how my DataGridView is populated:
DataView MyDataView = new DataView(MyDataTable);
MyDataGridView.DataSource = MyDataView;