I have a windows forms application that need to check to see if a user has access to a specific form before it loads.

I have the sql query working in management studios, now I need to get the results into VB in a list or array or something else that will work.

I know how to get the windows username, that isn't a problem.

This Query works like I need it to in Management Studio:

Code:
SELECT  Attendance.UserName
FROM Attendance INNER JOIN
           Reviews ON Attendance.ReviewID = Reviews.ReviewID
WHERE reviewdate = Convert(date, getdate())
The results from this query will generally be less than 10 names.

I am going through a brain block, I can't seem to work out the best way to get the sql results into a simple format in vb to check against.

Thank you,

Steve Hathaway