is DataSet have a Contain or In functionality?
i just wanna to know if the X data exist in database.

Normaly i use SqlDataReader, take a loop SqlDataReader put variable in array or List.
<br>
and in Business layer again looping the array or List and compare with the X data if is in the list or array.

     SqlDataReader readerOne = comm_SelectOne.ExecuteReader();
                    while (readerOne.Read())
                    { ... }

i think there are not efficient, there are 2 loop (in Data acces layer to Collect and in Bussinnes layer to compare)

is there anothre way to do that  ? with DataSet ? 

Thanks you in advance,
Stev
is DataSet have a Contain or In functionality?
===

i just wanna to know if the X data exist in database.

Normaly i use SqlDataReader, take a loop SqlDataReader put variable in array or List.
<br>
and in Business layer again looping the array or List and compare with the X data if is in the list or array.

     SqlDataReader readerOne = comm_SelectOne.ExecuteReader();
                    while (readerOne.Read())
                    { ... }

i think there are not efficient, there are 2 loop (in Data acces layer to Collect and in Bussinnes layer to compare)

is there anothre way to do that  ? with DataSet ? 

Thanks you in advance,
Stev