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