Medyo hindi ko maintindihan yung code pero using adodb mas madali.
1st way.
Dim cn as new ADODB.Connection
Dim rs as new ADODB.Recordset
Hindi ko kabisado yung code pero Initiate mo yung connectionstring then eto
cn.Open
rs.Open "select * from tblLogin where username = '" & txtusername.text & "'", cn, adOpenDynamic, adLockOptimistic
If rs.EOF then
'Ibig sabihin neto wala syang nakita na ganun username
Msgbox 'ikaw na bahala sa msg
rs.Close
cn.Close
Else
'Eto naman pag existing, dito mo check kung tama yung password
If rs("password") = txtpassword.Text then
'Eto pag tama pass. Ikaw na bahala basta iclose mo both rs and cn
Else
'Eto pag mali. Iclose mo din rs at cn
End If
End If
Sorry tinype ko lang code gamit cp. Sana nakatulong.