Dear Users

my recordset returns a (-1) why does this happen if I know that there are no records present? (adoRS = -1)

Dim rs As ADODB.Recordset = New ADODB.Recordset()
        Dim adoRS As Recordset = New Recordset()
        adoRS.Open(strSQL, adodbConnection, CursorTypeEnum.adOpenForwardOnly, LockTypeEnum.adLockReadOnly, 0)


        If adoRS.RecordCount <> 0 Then
            adoRS.MoveFirst()
        End If

May I ask why you are using ADODB in .net? Unless you really really have to, I'd recommend using the new ADO.net classes. You'll get much better functionality out of them.

Peter
------------------------------------------------------
Work smarter, not harder.