using DevExpress.XtraGrid.Views.Base;

ColumnView View = gridControl1.MainView as ColumnView;
View.BeginUpdate();
try {
   int rowHandle = 0;
   DevExpress.XtraGrid.Columns.GridColumn col = View.Columns["Category"];
   while(true) {
      // locating the next row
      rowHandle = View.LocateByValue(rowHandle, col, "SPORTS");
      // exiting the loop if no row is found
      if (rowHandle == DevExpress.XtraGrid.GridControl.InvalidRowHandle)
         break;
      // perform specific operations on the row found here
      // ...
      rowHandle++;
   }
} finally { View.EndUpdate(); }

Dim View As DevExpress.XtraGrid.Views.Base.ColumnView = GridControl1.MainView
View.BeginUpdate()
Try
   Dim RowHandle As Integer = 0
   Dim Col As DevExpress.XtraGrid.Columns.GridColumn = View.Columns("Category")
   While (True)
      ' locating the next row
      RowHandle = View.LocateByValue(RowHandle, Col, "SPORTS")
      ' exiting the loop if no row is found
      If RowHandle = DevExpress.XtraGrid.GridControl.InvalidRowHandle Then
         Exit While
      End If
      ' perform specific operations on the row found here
      ' ...
      RowHandle += 1
   End While
Finally
   View.EndUpdate()
End Try

using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Views.Card;
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraGrid.Columns;
// ...

public int LocateRowByMultipleValues(ColumnView view, GridColumn[] columns, 
object[] values, int startRowHandle) {
   // checking whether the arrays have the same length
   if (columns.Length != values.Length) 
      return DevExpress.XtraGrid.GridControl.InvalidRowHandle;
   // obtaining the number of data rows within the view
   int dataRowCount;
   if (view is CardView)
      dataRowCount = (view as CardView).RowCount;
   else
      dataRowCount = (view as GridView).DataRowCount;
   // traversing the data rows to find a match
   bool match;
   object currValue;
   for (int currentRowHandle = startRowHandle; currentRowHandle < dataRowCount; 
   currentRowHandle++) {
      match = true;
      for (int i = 0; i < columns.Length; i++) {
         currValue = View.GetRowCellValue(currentRowHandle, columns[i]);
         if (!currValue.Equals(values[i]))
            match = false;
      }
      if (match)
         return currentRowHandle;
   }
   // returning the invalid row handle if no matches found
   return DevExpress.XtraGrid.GridControl.InvalidRowHandle;
}

Imports DevExpress.XtraGrid.Columns
Imports DevExpress.XtraGrid.Views.Base
Imports DevExpress.XtraGrid.Views.Grid
Imports DevExpress.XtraGrid.Views.Card
' ...

Public Function LocateRowByMultipleValues(ByVal View As ColumnView, _
ByVal Columns As GridColumn(), ByVal Values As Object(), _
ByVal StartRowHandle As Integer) As Integer
   ' checking whether the arrays have the same length
   If Columns.Length <> Values.Length Then
      Return DevExpress.XtraGrid.GridControl.InvalidRowHandle
   End If
   ' obtaining the number of data rows within the view
   Dim DataRowCount As Integer
   If (TypeOf (View) Is CardView) Then
      DataRowCount = View.RowCount
   Else
      DataRowCount = CType(View, GridView).DataRowCount
   End If
   ' traversing the data rows to find a match
   Dim Match As Boolean
   Dim CurrValue As Object
   Dim CurrentRowHandle, I As Integer
   For CurrentRowHandle = StartRowHandle To DataRowCount - 1
      Match = True
      For I = 0 To Columns.Length - 1
         CurrValue = View.GetRowCellValue(CurrentRowHandle, Columns(I))
         If Not CurrValue.Equals(Values(I)) Then Match = False
      Next
      If Match Then Return CurrentRowHandle
   Next
   ' returning the invalid row handle if no matches found
   Return DevExpress.XtraGrid.GridControl.InvalidRowHandle
End Function

GridColumn[] cols = new GridColumn[] {colCategoryName, colCategoryID};
object[] values = new object[] {"Condiments", 2};
int rowHandle = LocateRowByMultipleValues(gridView1, cols, values, 0);

Dim Cols() As GridColumn = New GridColumn() {colCategoryName, colCategoryID}
Dim Values() As Object = New Object() {"Condiments", 2}
Dim RowHandle As Integer = LocateRowByMultipleValues(GridView1, Cols, Values, 0)