VB.NET - getting data from Recordset
Converting to .NET from ver6
I am having a lot of issues understanding the .NET way of working with DATA. Before, I could look up a dataset from Access, and then look at a particular Column name (ie: ACTIVE) to see if they are an authorized user.
How can I do this in .NET?
=====================
Code:
Dim db As Database
Dim dblocation As String
Dim ssql As String
Dim rsusers As Recordset
dblocation = App.Path & "\mtb.mdb"
Set db = OpenDatabase(dblocation)
ssql = "SELECT * FROM USERS where username = '" & mytext1 & "'"
Set rsusers = db.OpenRecordset(ssql, dbOpenDynaset)
If rsusers("ACTIVE") = True Then
'If user Exists, check password, etc.
elseif rsusers("ACTIVE")=False then
'User is not authorized. Terminate program.
end if
