>Is it possible for me to find a record in a datareader .. I use below code .. (I don't want to use "Where clause in my SQL statement")
>
>Dim mKode as string
>Dim mSQLCheckData As String = "Select * from MyTable01 Order by Kode"
>Dim DataReader As SqlDataReader
>
>Dim SQLCommand As New SqlCommand(mSQLCheckData, SqlConnection1)
>
>SqlConnection1.Open()
>DataReader = SQLCommand.ExecuteReader()
>
>--
>--
>--
>
>SqlConnection1.Close()
>
>please help
>
>TIA
>
>Winanjaya

Winan,

You would have to loop through the DataReader and test each row for the record you are looking for.