Ahmad,

You could write your own find method, something like this (untested code):

public DataRow MyFind(DataTable MyTable, string ColumnName, object ColumnValue)
{
  for (int i=0; i < MyTable.Rows.Count; i++)
  {
    if (MyTable.Columns.Contains(ColumnName) && MyTable.Rows[i][ColumnName] == ColumnValue)
      return MyTable.Rows[i];
  }
  // if none found, return a blank row.
  return new DataRow();
}

~~Bonnie



>Hi Jayesh,
>
>Regarding the Find() method, I works only with PK's, what if I want to search for some data in not a PK column, .Find will not work...
>
>Select statment with Where clause is only the choise ??
>
>
>
>
>>DataRowCollection has Find() method. You can do something like this:
>>
>>

myDataSet.Tables[myTable].Rows.Find(CustomerId);

>>
>>>Dear All,
>>>
>>>Is there a way to seek the DataSet (ADO.NET) like old ADO?
>>>if not how to find records, is't by using sql commands only?
>>>
>>>Thanks for the help