Thanks Bob.


>DataRow[] srow = dataset.table[0].Select("fieldname = 'value'")
>
>ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpref/html/frlrfsystemdatadatatableclassselecttopic.htm
>
>BOb
>
>
>
>>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