Assigning A DB Value To A Variable

Consider the following:





Sub regUser(s as Object, e as EventArgs)





If IsValid Then





Dim stuTable as String


Dim connStr as String





stuTable = "mytable"


connStr = "myConnectionInfo"





'check to see that student num is in the db


Dim connect as SqlConnection


Dim strSelect as String


Dim cmdSelect as SqlCommand


Dim strDbResult as SqlDataReader





connect = New SqlConnection(connStr)


strSelect = "SELECT stu_num, stu_fname, stu_lname FROM " + stuTable + " WHERE stu_num=@stuNum"


cmdSelect = New SqlCommand(strSelect,connect)


cmdSelect.Parameters.Add("@stuNum", txtStdNum.text)





connect.Open()


strDbResult = cmdSelect.ExecuteReader()





Dim stuFName as String


Dim stuLName as String


Dim stuEmail as String


Dim strRandom as String


Dim strPassword as String


Dim i as Integer


Dim charIndex as String


Dim stuMailMessage as MailMessage


Dim strHTMLBody as String





'declare stuFname, stuLname, stuEmail


stuFName = strDbResult("stu_fname")


stuLName = strDbResult("stu_lname")


stuEmail = txtStdEmail.text





'more code follows ....





In my DB I have a table with the columns stu_num, stu_fname and stu_lname. Each of these columns contains rows with data. However, the proceeding code gives me this error: Invalid attempt to read when no data is present (line 58 --> stuFName = strDbResult("stu_fname") ).





What am I doing wrong here? How do I assign the stu_fname in the DB to the page level variable stuFName?





As a little aside how do I say "If no record was found matching stuNum Then" ... ??





Sorry, I'm a .NET beginner ...