Retrieving index for a particular row from dataset

[Diffident]

Hello All,

Was wondering if we could retrieve the index of a particular row from a
dataset's table based on the filter criteria for the row?

For example, I have 4 rows in my datatable which is inside a dataset. One of
the columns is "ID" field. If I want to retrieve the row index of a row with
ID = 10, is there any API which I could use in .NET framework.

I am using a kinda beginners code to compare each and every row's ID in a
for loop and deriving the index. If my datatable has >10000 rows, this
procedure is very inefficient.

Is there any efficient way to retrieve a row index?

TIA,
Diffi

[Craig Deelsnyder]

On Wed, 30 Mar 2005 14:45:04 -0600, Diffident
<Di*******@discussions.microsoft.com> wrote:

Hello All,

Was wondering if we could retrieve the index of a particular row from a
dataset's table based on the filter criteria for the row?

For example, I have 4 rows in my datatable which is inside a dataset.
One of
the columns is "ID" field. If I want to retrieve the row index of a row
with
ID = 10, is there any API which I could use in .NET framework.

I am using a kinda beginners code to compare each and every row's ID in a
for loop and deriving the index. If my datatable has >10000 rows, this
procedure is very inefficient.

Is there any efficient way to retrieve a row index?

TIA,
Diffi

Is the sort based on "ID"? If so, you can use a DataView:

http://groups-beta.google.com/group/...11bccc202ca28c

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET