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