Bonnie,

I think your code goes and search row by row, correct?
So, what if my database table have 70,000 row's !!, the system will be very slow.
Correct or I am missing something here?



>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