Ahmad,

Your database table may have 70,000 rows, but I doubt that you will have that many rows in your DataSet!! If so, you need to make your DataSet a bit smaller with a WHERE clause in your SELECT. There's no way the UI should be handling that many rows.

~~Bonnie


>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